Table of Contents Let’s suppose we receive inventory files from our provider, and we need to upload these stock counts in our ERP system every time we get these files. The file format our ERP system requires is a CSV document but the file from the provider is in XLSX format. In this blog we […]
Convert Excel file to CSV format with Power Automate (xlsx to csv) Read More »
We want to analyze how invoicing works in our company, and we would like to find out which service category is the one we’re selling the most and which we could improve. So, we pull data related to all invoices we’ve sent to clients, and we find the following table: As you notice, invoice line
Lookup by keyword in DAX | Contains Logic | Power BI and Power Pivot Read More »
Either because we created too many rows when we were testing or because requests are no longer applicable, the approvals module in Power Automate can end up with plenty of requests that do not require action: In this blog we will show you how we can use Power Automate and Dataverse to cancel old requests.
Cancel old approval requests sent from Power Automate | Dataverse approvals Read More »
A couple of weeks back, we posted this article on how to extract the content of a .eml file using Power Automate, but we recently discovered that there are some instances where the approach we explain in the previous blog will not work. The first approach we presented relies on the Power Automate Outlook trigger to
How to recognize .eml files with Power Automate? | Hidden attachments Read More »
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
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 »
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 »
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 »
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 »
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 »
