cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

check docset metadata value and update

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
rsaikrishna
Community Champion
Community Champion

@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. 

 

3.JPG

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

4.JPG

 

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.

View solution in original post

3 REPLIES 3
rsaikrishna
Community Champion
Community Champion

@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. 

 

3.JPG

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

4.JPG

 

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
Not applicable

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
Community Support
Community Support

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,845)