cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
egornua1
Helper IV
Helper IV

update document set metadata

Hello,

 

I have a document set and a list.

I am trying to update the document set metadata with metadata from the list, where the only common value is a transaction number. (Internal ID's differ).

 

I have tried the Get action to get the data from the list and apply to the document set metadata but its failing.

 

Thank you for your time

 

doc set1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Hello @egornua1 ,

you don't need 'Get items', you already have all the information about the item from the trigger. Try using 'Get files (properties only)' to find the new file in the document library, and then use the ID returned by 'Get files...' to update the file.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

View solution in original post

12 REPLIES 12
tom_riha
Super User
Super User

Hello @egornua1 ,

it would be helpful to see what error it returns, but on the first look I can see that you're missing closing bracket after the ID dynamic content in Uri.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
egornua1
Helper IV
Helper IV

@tom_riha - thanks for taking the time to look Tom.

 

Below is the error. 

I don't think i have the association correct.

The ID's differ in each list/library. The only common thing is a customer order number (CO) between the two.

 

{"odata.error":{"code":"-2130575338, System.ArgumentException","message":{"lang":"en-US","value":"Item does not exist. It may have been deleted by another user."}}}
clientRequestId: b0f0c563-51c7-4e66-aa64-ebe85552e7a9
serviceRequestId: 7830bf9f-b0ec-b000-f9f8-e5b2a5f18ed0

Then you must get the ID of the document set using the CO value. Get the right item / document set with the 'Get items' or 'Get files (properties only)' using a Filter Query (depending on what's the source and what's the update target). Search only for the item / document set where the CO value is equal to the CO value from the other source, and then use the ID from the result in the update.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
egornua1
Helper IV
Helper IV

@tom_riha - Thank you.

 

I am new to Flow so will need to learn how to do that.

Thanks again for helping.

egornua1
Helper IV
Helper IV

@tom_riha - i have tried to do your suggestion but unsure how to associate. 

Do you know of any examples, where there are flow screen shots?

Thank you

egornua1
Helper IV
Helper IV

Can anyone please advise on the steps below and flow attached.

Step 1 - when an item is created in the list

Step 2 - Create a document library entry based on step 1.

Step 3 - Get items from step 1 list

Step 4 - Update metadata from step1 list to document library from step 2

 

CO No. being the only common field between list and library

Steps 1 & 2 work fine, its getting the additional metadata field that hasn't worked.

 

steptaken.PNG

egornua1
Helper IV
Helper IV

Is there any alternative i can use in step 4 above?

 

Step 1 to 3 seem to work but its failing in step 4 as the ID's wouldn't be the same for the list and library but i don't know an alternative.  

Thank you for your time.

 

Hello @egornua1 ,

you don't need 'Get items', you already have all the information about the item from the trigger. Try using 'Get files (properties only)' to find the new file in the document library, and then use the ID returned by 'Get files...' to update the file.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
egornua1
Helper IV
Helper IV

Hello @tom_riha .

 

I cannot seem to find the correct file in the 'Get Files properties portion.

 

Can you help me please. Screen shot below.

 

updateTim.PNG

egornua1
Helper IV
Helper IV

@tom_riha - i have it working.

I was updating with wrong process owner field rather than the process owner in the trigger field.

 

After testing there is a problem. 

As the entries are added to the document library, they are updating the previous entries with the same metadata and not specific to that line.

Can you suggests how to find that specific entry in Get file properties?

 

Thank you for helping.

Hello @egornua1 ,

use the same Filter Query as in the 'Get items' action, that way it should return only the document set with the CO NO. you need.

image.png



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
egornua1
Helper IV
Helper IV

@tom_riha - Thank you.

I used Title eq CO No, where title represents CO No in document library and CO NO. being value in trigger.

This seems to be working great.

 

Thank you so much for the support, it really is beneficial to people who are only new to power automate.

i took the opportunity to check out your blog as well and will continue to read it as i learn. 

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.

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.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,777)