update document set metadata

(0) Share

Report

Posted on by egornua1

364

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

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

@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

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

@tom_riha - Thank you.

I am new to Flow so will need to learn how to do that.
Thanks again for helping.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

@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

Was this reply helpful? Yes No
egornua1 364 on at

Like (1)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

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.

Was this reply helpful? Yes No
egornua1 364 on at

Like (0)

Report

Re: update document set metadata

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

Was this reply helpful? Yes No