Getting document name and put it in approval list

(0) Share

Report

Posted on by Appleonwindows

129

Hi,

I have file with version name where i would like to put it into the approval list so that it can show which version of the file we are currently using. But it seems like i am not able to initialize and set the variable to the file name.

I have set up the flow to filter Form56 but it gave me a list of table, then i tried to take out the file name from the table, it does not work.

Please advice.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Manish Solanki 15,099 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @Appleonwindows

To get the file name & version number, you don't require looping the "Get files (properties)" action. Pls modify the flow as per below sample flow:
1. After "Get files properties" action, add "Fiter array" action to filter the records based on the name:

2. As filter array action returns an array so we will fetch the first element of the array using first() formula and then fetch the properties 'file name with extension' and 'version number':
Expression needs to be written in expression box, below is the expression used for getting the file name with extension:
first(body('Filter_array'))?['{FilenameWithExtension}']
Similarly, we will get the version number in another compose action using the expression:
Expression used for getting the version number:
first(body('Filter_array'))?['{VersionNumber}']
You can use the output of compose action to show the file name & version number in the approval action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Appleonwindows

The "Get file properties" action will consistently return a table, even when it contains just a single row.

To streamline the process, you can utilize a Filter query within the action to ensure the return of a unique record.

By incorporating an "Apply to each" loop, it will execute only once.

Note that variables cannot be set within a loop; you should employ a compose action instead.

Was this reply helpful? Yes No