How to Dynamically Retrieve Content of Newly Created Excel File in OneDrive for a Power Automate Flow?

[HamidBee]

Hi,

I'm setting up a Power Automate flow that is triggered when a new Excel file is placed into a specific OneDrive folder. My flow is supposed to take this Excel file and append its contents to a table in Dataverse.

I have set up my trigger to start the flow when the file is created. However, I'm a bit stuck on the step immediately following the trigger, where I need to retrieve the content of the newly created file using the 'Get file content' action from OneDrive for Business.

The action is asking for a 'File Identifier', and I'm unsure how to dynamically specify the most recently created file, as I won't know the file path beforehand. Could someone guide me on how to use the dynamic content output from the trigger to reference the correct file?

Also, if there are multiple files created at the same time, how would the flow know which one's content to retrieve? I'm looking for a solution that ensures the correct file is processed each time the flow runs.

Any insights or guidance on this would be greatly appreciated. Thank you in advance for your help.

[SudeepGhatakNZ · Accepted solution]

@HamidBee ,

If there are multiple files created, a flow instance will be triggered for each file separately. If you want the flow to run for a specific file, you need to add a condition action after the trigger.

[HamidBee]

Thanks for getting back to me.