Update file Properties on output of ODATA filter query

[SylvieLet17]

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!

[v-yamao-msft · Accepted solution]

Hi @SylvieLet17,

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

[SylvieLet17]

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!