Want to update SPLIST metadata column values from excel.

(0) Share

Report

Posted on by Eswar1

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.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (2)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Eswar1

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

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Eswar1 60 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

MattWeston365 1,701 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No