Answered

Update File Properties on sharepoint document library from excel

(0) Share

Report

Posted on by ENkay1

Looking for some help. Trying to update sharepoint document file properties using excel list. I already have the excel export iqy file now in a xslx / table. hosted in a sharepoint document lib.

cannot seem to get 'ID' from excel list as an option to config on the update file properties action- as ID.

i am defo looking for a loop because I have mutiple records to update from excel rows to sharepoint doucment lib items.

any help appreicated, Screenshot 2019-10-03 at 14.57.35.png Screenshot 2019-10-03 at 14.56.57.png

Screenshot 2019-10-03 at 14.54.04.png Screenshot 2019-10-03 at 14.55.45.png

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (2)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @ENkay1

Flow step Update file properties you need to map the Id. From your screenshot I can see you are mapping the current item of the loop. So from the loop it should expose the properties of the row where you must have the Id for each row which can be used for update file properties.

Regards

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
ENkay1 21 on at

Like (0)

Report

Thats my problem i cannot see nor pick the ID field from excel (green) in my config.

what is going on ?

Was this reply helpful? Yes No
ENkay1 21 on at

Like (0)

Report

thats my problem, i cant for the life of me. map the ID field (green on) from excel. it only shows the current item as an option.

is my loop incorrect or somthing .

Was this reply helpful? Yes No
ENkay1 21 on at

Like (0)

Report

Thats the problem i cannot select ID in tha field. @abm

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ENkay1

Got your message. Not sure why you can't reply to this thread.

Under the Dynamics Content start typing the properties. Sometimes not all properties are displayed by default.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
ENkay1 21 on at

Like (0)

Report

@abm is helping

Was this reply helpful? Yes No
ENkay1 21 on at

Like (0)

Report

@abm is being super helpful

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @ENkay1

Thanks for the screenshare. So we have resolved the first issue which was the list update. Next issue is the meta data update. Have a look at this blog https://flow.microsoft.com/en-us/blog/managed-metadata-tago/

Let me know how it goes.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @ENkay1 ,

It seems that the type of the ID in the Excel table does not match the type of the ID field in the Update file properties, so there is no ID displayed in the Dynamic content option.

Please try to use Compose to store the ID field in the Excel table and then configure the output of Compose in the ID field of the Update file properties action.

Please take a try.

Best Regards,

Was this reply helpful? Yes No
ENkay1 21 on at

Like (1)

Report

I rate @abm as the leading authority on designing very extensive and complex flows. In addition hes taken so much time out and gone to lengths to mentor me are share his knowledge.

For clarity the above flow only scratches the surface of what my requirement was. @abm took time out of his own schedules to support me every step of the way. I am so grateful to you !!! and indebted Thank you so much.

My flow was to add managed metadata to a column on a document library from a excel table.
this involved
Setting numerous variables, index, array and strings with split fucntions to count tags and building nested loops to suport mutiple items and tags.
BIG BIG THANKS

I am will be sure to hang around here and learn more. - what didnt help was i couldnt post or reply to thread on this forum to begin with.

Was this reply helpful? Yes No