Update file Properties on output of ODATA filter query

(0) Share

Report

Posted on by Community Power Pla...

Hi all,

What exactly can I do with the Output of a Get Files (properties only) action?

I'd like to update the metadata on the files that this action retrieves but I have no idea where to begin.

Of course the output of that action is an Object and I'm new to dealing with Objects.

I tried messing with Variables to get the ID and Path of the document so that I could then use an "Update file properties" action, but I can't use any string functions to get those values on the Object output. I know it sounds like a messy way to do it, but I am lost.

Here's the sequence of my flow:

When a document is copied to Library A

start an approval

if Approval Response == yes

get files (properties only) in Library B with filter: Title eq 'value'

update those files to: Status = Published and Publishing Date = UTCNow

Please help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yamao-msft on at

Like (0)

Report

Hi @Anonymous,

Do you want to update file properties of files that filtered by Odata filter query?

I have made the following test, please take it for a reference.

It is triggered by When a file is created in a folder.

Start an approval, if the Response is equal to Approve, Get files from Library2, the filter query is configured as:

Title eq ‘BugList’

Then Update file properties, Status to Published, and Publishing date to Utcnow.

Image for your reference.

Best regards,

Mabel

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks Mabel,
I was just getting an error message when I built the flow, but it still runs fine regardless. Not sure what was up!

Thanks!

Was this reply helpful? Yes No