Update Metadata of excel files on Shearpoint libery from table values on these Excel files

Like (1) Share

Report

Posted on 14 Mar 2025 12:17:39 by CJ-14031156-0

Hi,

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

Can you help me please to find the right flow?

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

Jacqui Muller 46 on 14 Mar 2025 at 13:00:47

Like (0)

Report

Update Metadata of excel files on Shearpoint libery from table values on these Excel files

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!