Extract Value from Array in Power Automate Asked 1 year, 5 months ago Modified 1 year ago Viewed 8k times You can retrieve the contents of the CSV file using the Get file content action in Power Automate/Microsoft Flow, and then using the Parse CSV action to transform the file contents into a structured format that can be used in subsequent actions in your flow. For instance, you may send emails, update a database, or add items to another SharePoint list using the parsed data. I'm working on a Power Automate flow that updates items in a SharePoint Online list.

Understanding the Context

However, I'm facing an issue where certain columns (including Person/Group fields) are not appearing in the "Update item" action. Power Automate – Some SharePoint List Columns Not Appearing in "Update ... You are confusing Power Automate with Power Automate Desktop. The link you provide is for Power Automate, so those functions won't work in the PADesktop.

Key Insights

There is an action named Convert datetime to text in PAD, you can specify the formats you would like there The action lets you pick from existing formats or you can specify one. copy this code to PAD to see a custom example Text ... I am trying to load (combine) multiple Excel files into Power BI (October 2019 version). Every file has only 1 sheet. Each sheet has 1 range, and each range has the same schema across all files.

Final Thoughts

... excel - how to resolve Power BI error - the key didn't match any rows ... Both approaches work OK in Power BI desktop report, However once I published to Power BI service and after several refreshes (initially it was NZ time), the time turn back to UTC time. I don't want to create extra columns in DAX and really want to try use Power Query. Is there any way to work it out?