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
Solved! Go to Solution.
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.
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.
@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.
@tom_riha - Thank you.
I am new to Flow so will need to learn how to do that.
Thanks again for helping.
@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
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.
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.
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.
@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.
@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.
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
38 | |
24 | |
21 |