I want update a metadata column by the value of the excel files.
I have a Libery, which contains a lot of excel files which contains a similar structure. For this reason thes contains all a Table with similar Name. I tray to find a flow, but I have problems to separate the output of "Get a row", to update only 1 of the value in the Metadata:
Here my current flow (for the tests, I work with "Get file properties" but later it will be "Gets files properties" to update all Excel files)
On compose, I have currently this output:
Finaly I want to have the value of "Observations" in the metadata. I tray a little bit with variable, select, filter, ... But with no success. I think It need to do with some expressions, but I don't kow
Hi @CJ-14031156-0, so for this example, the following expression should work:
outputs('Compose')?['Observations']
If you change the action name and it becomes Compose1 for example then make sure you change the above code to outputs('Compose1')?['Observations']
As soon as you use the get files action, your object structure might look difference and this might now work, then a Select might work better.
Please shout if that doesn't work!
Was this reply helpful?YesNo
Under review
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 (
