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 »

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 »