SharePoint

Excel

Read Raw Excel Data (unformatted xlsx) using Power Automate | Excel File to SharePoint List

Power Automate has some cool out-of-the-box features to read data from Excel files. But if you want to read this data using these actions, the data needs to be formatted as an actual table in the file and not a flat range – but don’t you worry, Office Scripts got you covered!  With Office scripts …

Read Raw Excel Data (unformatted xlsx) using Power Automate | Excel File to SharePoint List Read More »

Query Filter

Ultimate guide to OData query filters for SharePoint in Power Automate

When working with Power Automate and SharePoint lists we usually are in need of extracting specific rows of data from lists, to do so, we need to use the “Query filter” field available in the SharePoint “Get Items” action. OData queries are usually written in the following format:  {InternalColumnName} operator {value}  For example, if we …

Ultimate guide to OData query filters for SharePoint in Power Automate Read More »

Get content of a file attached in an email’s .eml attachment (nested attachments)

Quite recently we were working with the Accounts Payable team to automatically grab invoices received from suppliers and save them in a SharePoint site, we were using the regular “For each attachment”, “Attachment content” and then “Create file” actions in Power Automate for most vendors, until we found one vendor who did not attached their …

Get content of a file attached in an email’s .eml attachment (nested attachments) Read More »

Create long-running approval requests in Power Automate (override 28-days timeout)

Sending approval requests is one of the most common use cases for which Power Automate is used for. After all, the out-of-the-box connector for approvals has a limitation: if the approval request is not approved or rejected within 28 days, the action will time out and this will cause your flow to fail. In this …

Create long-running approval requests in Power Automate (override 28-days timeout) Read More »

Update connection references in a Managed solution – Power Platform

A connection reference, a key component in a solution, contains vital information about credentials used to connect to a Power Platform connector. During the import of a managed solution into an environment, users face a choice: selecting an existing connection or creating a new one. It’s crucial to note that, once a managed solution is …

Update connection references in a Managed solution – Power Platform Read More »

Azure Function App: upload files to SharePoint from a public URL

This blog will show step by step how to create an Azure Function App to upload files to SharePoint using C#. This code will receive a public URL that contains a file to download, and we will upload this file to SharePoint, using the Graph API – and by the way, this function was created …

Azure Function App: upload files to SharePoint from a public URL Read More »

Power Automate Desktop

How to upload files to SharePoint from Power Automate Desktop?

When we are using Power Automate Desktop to download files from the web, it’s a very common use case to want to upload them to a SharePoint site. There are two ways to achieve this, depending on if you have a Power Automate Premium account or if you don’t.  Content Option 1. You have a …

How to upload files to SharePoint from Power Automate Desktop? Read More »

Write to dynamic Excel files using Power Automate

You have an MS Excel template that needs to be filled out every time a new record in SharePoint is created: this means when a new item is added in SharePoint, a copy of the template needs to be created and our automation has to insert rows into it. In our example, we have a …

Write to dynamic Excel files using Power Automate Read More »

Fill out dynamic MS Word templates with Power Automate

Our use case: A word file needs to be generated everytime a new application is submitted – with some fields that come from the application form such applicant’s first name and last name. Someone reviews the request, performs manual updates to the file and sends it for approval. When the file is submitted for approval, …

Fill out dynamic MS Word templates with Power Automate Read More »