Skip to main content

Notifications

Power Automate - General Discussion
Answered

Want to update SPLIST metadata column values from excel.

(0) ShareShare
ReportReport
Posted on by 60

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 librarySP Document libraryCapture.PNGerroe.PNGexcelfile.PNGflow.PNGSPLIST.PNG

 

Says list item not found, already SP list and Excel have same values, please help.

  • Verified answer
    MattWeston365 Profile Picture
    MattWeston365 1,701 on at
    Re: Want to update SPLIST metadata column values from excel.

    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.

    Termstore.PNG

  • Eswar1 Profile Picture
    Eswar1 60 on at
    Re: Want to update SPLIST metadata column values from excel.

    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:

     

    SPLIST.PNGflowrun.png

     

     

    Still showing as Approved, instead of Applicant, Please suggest this is my excel file.

     

    excelerror.PNG

     

    Kindly Suggest.

     

    Regards,

    Eswar T

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Want to update SPLIST metadata column values from excel.

    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.

    1.PNG2.PNG

     

    Best regards,

    Mabel

     

  • Eswar1 Profile Picture
    Eswar1 60 on at
    Re: Want to update SPLIST metadata column values from excel.

    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: 

     

    1.png

    Error :

    2.png

     

    SPLIST:

    3.png

     

    Excel:

     

    4.png

     

    Basically want to update column2 metadata value to SPlist colum2 value, kindly suggest.

     

    Regards,

    Eswar

     

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Want to update SPLIST metadata column values from excel.

    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

     

  • Eswar1 Profile Picture
    Eswar1 60 on at
    Re: Want to update SPLIST metadata column values from excel.

    Hi ScottShearer

     

     

     

    updateerror.PNGupdateeror2.PNG

     

    Kindly Suggest.

     

    Regards,

    Eswar

     

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Want to update SPLIST metadata column values from excel.

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

    UpdateSP.jpg

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard