Read Rows in Excel Using Power Automate with ‘Create Table’ Action When working with Excel files that need to be imported into a SharePoint list, you may encounter scenarios where the data is not already in table format. This can be challenging, especially if the Excel files are automatically generated by an external system and cannot be manually updated. This blog post demonstrates how to dynamically convert raw data into a table using the Create Table action in Power Automate and subsequently read rows using the List rows present in a table action.

Power Automate: Save Run Flow URL to SharePoint List Item When running a Power Automate flow, capturing and saving the flow’s run URL to a SharePoint list item can simplify troubleshooting and auditing. This allows you to easily revisit the flow run details in case of failures or for review purposes. However, note that flow run URLs are only available for 30 days, so older links may no longer work.

Exploring some Limitations of Copilot in Power Automate I was thrilled when Copilot became available in the UK region within Power Automate around mid-November 2023. To understand its functionalities and limitations, I started exploring. Please refer to Understanding the Cloud Flows Designer, which outlines some limitations and described the Flows Designer experience. Creating New Flows While creating a new flow using the prompt “Start an approval process and update the item in a SharePoint list when a new item is created,” I noticed a functional flow generated.

Converting a HTTP Trigger into a Child Workflow in Power Automate Using a HTTP trigger requires Premium licence and with the Child Workflow in a solution alleviates the need of premium license. Other advantages using a solution: Application Lifecycle Management: Facilitates deployment. Child Workflow: Allows for a more modular and manageable flow structure. Easier Ownership Management: Simplifies updates to the flow owner. I recreated the child workflow within the solution selecting the Manually trigger a flow trigger and updated the parent flow to use the flow as child workflow.

Updating Approval Details in SharePoint Library using ‘Send HTTP Request to SharePoint’ in Power Automate In Power Automate, there are two methods for updating file properties: Send HTTP Request to SharePoint Update File Properties While the latter suffices for most cases, I opted for the “Send HTTP Request to SharePoint” in specific scenarios: To avoid triggering a new file version using system update. When modifying system columns such as author or modified date.