Update File Properties on sharepoint document library from excel

[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, 

[abm · Accepted solution]

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

[ENkay1]

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

what is going on ? 

[ENkay1]

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 .

[ENkay1]

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

[abm]

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

[ENkay1]

@abm is helping 

[ENkay1]

@abm is being super helpful

[abm]

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

[v-bacao-msft]

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,

[ENkay1]

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. 

[abm · Accepted solution]

Hi @ENkay1 

Thank you for your kind comments. Below is the flow we discussed. 

The above expression is as follows:

length(split(variables('metadatavalues'),';'))

The above expression is as follows:

split(variables('metadatavalues'),';')[variables('index')]

The last step initalise metadata array null is incorrect.  Declare another empty array at the begining of the flow. Set the empty array here to metadatarray. This way we can initialise the array.

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

[traceyannspence]

Hello,  ABM, 
I'm trying to do something very similar to this user, I'm reviewing your tutorial channel which is very helpful. Do you have a couple specific videos you'd recommend for replicating this process?
Thanks in advance for your help. 

[abm]

Hi @traceyannspence 

Could you post a new thread and your requirements in details please? Tag me @abm  so that I will get notified and I will have a look.

Thanks

[traceyannspence]

Thanks so much. I did as you requested. 

Thanks again in advance.