Hello, I have an application where the user is able to view reports, and it needs to allow the user to select documents and then have them emailed.
Right now, I have set it up so that the document IDs are are saved to a collection, then brought over to Power Automate. The first step of my Flow is to Parse JSON.
The issue is, I now have to Get File Properties using those IDs, and this is where I am having trouble. I am not too sure how to query the data so that it grabs all of the correct documents based on the IDs brought over from the application. Any help would be appreciated.
Here is the sample flow. I have used an input parameter of string type that holds the array of file Ids as integers.
If there are more than 100 files in document library then increase the pagination threshold size to 100000 from the setting of get files properties action
Add compose action after get files properties action. In this action, add expression to convert string to an array of file ids. Expression needs to be added in the 'Function' window. Please replace array input variable name as used in your flow:
Finally, add "Filter array" action to apply filter operation based on the array in output of compose action. Pass the body/value property from the output of get file properties in 'From' parameter. Similarly, pass the output of compose action and ID from get file actions while setting up filter query:
OUTPUT:
Passing value of input parameter:
Output of filter array after flow execution:
If this helps & solves your problem, please remember to like and accept my solution as it will help others in the future.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
