Dear Team,
I have a requirement update Sharepoint Metadata Column, List items with values provided in excel.
I have tried from my side however, I am getting an error can you guys please assit me?
Here is my List:
SP Document library
Says list item not found, already SP list and Excel have same values, please help.
Hi @Eswar1 is the list of terms in your Excel spreadsheet from the same tenancy as the SharePoint list you're trying to update? If not, the Unique Identified of your terms will differ from tenancy to tenancy. You can check this by going to the Term Store Management Tool and finding your term. At the bottom of the screen you'll see the identifier. If they mate, then please let me know and I'll try to dig a little deeper, but this is what I would check first.
Dear Mabel,
Thanks a lot for adressing the issue and providing the steps for the flow.
I am actually able to run the flow without any errors, but my SP List values are'nt getting updated.
Kindly, find attached Screenshots:
Flow Output:
Still showing as Approved, instead of Applicant, Please suggest this is my excel file.
Kindly Suggest.
Regards,
Eswar T
Hi @Eswar1 ,
Thanks for providing the detailed screenshot.
In action Update item, you should select dynamic content ID from action Get items, but not from Current item.
Please check the following flow configuration for a reference.
In action Get items, I am using Filter query to filter out items that have the same title.
Best regards,
Mabel
Hi Mabel,
That was what i wanted prior to it, I have done the same : selected the value field from excel from the action as suggested, but i got the following error.
Please find my flow, SPlist & Excel values.
Flow:
Error :
SPLIST:
Excel:
Basically want to update column2 metadata value to SPlist colum2 value, kindly suggest.
Regards,
Eswar
Hi @Eswar1 ,
Do you want to update SharePoint list managed metadata column with value from the Excel table?
If so, in the action Update item, you may need to select value from the Excel table but not from the list.
Please try again with it.
Best regards,
Mabel
Hi ScottShearer,
I have tried the steps you have mentioned, however there is a problem with my flow and it is throwing the following error.
PFA screenshot :
Kindly Suggest.
Regards,
Eswar
I believe that your issue is that in the Update item action, you need to reference the ID of the item from Dynamic properties rather than "current item".