Below you will find pages that utilize the taxonomy term “PowerAutomate”
posts
Display instagram posts into SharePoint using Instagram Basic Display Independent Publisher Connector
How to Use the Instagram Basic Display Connector in Power Apps and Power Automate Instagram is a popular social media platform with over 1 billion monthly active users. It is a great platform for sharing photos and videos, and many businesses use it to promote their products and services. With the Instagram Basic Display (IndependentPublisher) connector, you can now easily retrieve data from Instagram accounts and use it in Power Apps and Power Automate.
posts
Refresh long-lived token via Instagram Graph API
Learn how to automatically refresh long-lived access tokens using the Instagram Graph API. Refer to how the Long-Lived Access Tokens for more info.
Long-lived tokens are valid for 60 days and can be refreshed as long as they are at least 24 hours old but have not expired, and the app user has granted your app the instagram_graph_user_profile permission. Refreshed tokens are valid for 60 days from the date at which they are refreshed.
posts
Importing Dates and Numbers from Excel file into SharePoint list with Power Automate
Importing Dates and Numbers from Excel file into SharePoint list with Power Automate Transferring data from Excel to SharePoint lists can encounter format issues, especially with datetime and number fields. This post covers solutions to some challenges particularly related to dates and numbers.
The flow is quite simple with an action to read contents from excel file and an action to create items into a sharepoint list.
Handling DateTime Fields When importing datetime data with the “List rows present in a table” action from the “Excel Online for Business” connector, you might encounter format related errors.
posts
Converting a HTTP Trigger into a Child Workflow in Power Automate
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.
posts
Updating Approval Details in SharePoint Library using 'Send HTTP Request to SharePoint' in Power Automate
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.