check docset metadata value and update

[Anonymous]

Hi All,

New to power automate, but I am struggling with something that seems it should be simple.

I have defined DocumentSets.  I have defined custom columns on the document sets.

I then have a library to view the document sets created.  Which you then drill down to view the documents in that docset.

I want to create a flow, which when the user selects the created docset, it checks the status of one of the columns.

So

1) "For a Selected File" Trigger

2) Get the value of the 'Workflow Status' (Custom column)  (How do i get and check the value of the specific column when there are numerous)

3) If the value from 2 is 'x' then Update the column to 'y' else blank out the column  (how to update a specific column?)

Everything I see is getting the whole file and I don't see how to do a condition on a specific value.

I have been searching around and a it seems I may need to do http requests? it seems very complicated for what seems what would be a common scenario?

Any tips on the correct connectors and process appreciated.

thanks

[rsaikrishna · Accepted solution]

@Anonymous 

"For a selected file" trigger will not allow you to access custom properties of the file. It only provides you Name, Link to Item, ID. 

You can use the following way to get the file properties.

Please give a try and post here if you have any more questions.

Regards

Krishna Rachakonda

If my reply helped you solving the issue, please mark the reply as Accepted Solution.

[Anonymous]

Thankyou.  That makes sense.  So when I put a condition after the Get File Properties I can now see the fields I can validate.

Thanks

[Rei0116]

Hi, I agree with rsaikrishna's method, if you have any questions please let me know.