Skip to main content

Notifications

Power Automate - General Discussion
Answered

Update SharePoint Online library lookup column

(0) ShareShare
ReportReport
Posted on by 31

Hi,

 

I have a SQL table and need to sync that data to a SharePoint online library.

 

SQL table as follows,

NameType 1Type 2Type 3DateCountry

 

SharePoint Online library columns as same as above.

 

I did the Power automate flow development. But the issue is in SharePoint type1, type 2, type 3 are lookup columns from another lists. I'm able to do it for single line text field columns.

 

Can suggest how to update data to these lookup columns using flow?

 

Thanks

Categories:
  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint Online library lookup column

    Hi @sachk_1 ,

     

    Please check the flow I created using your logic:

    vjefferni_0-1703658790789.png

    vjefferni_1-1703659126281.png

    vjefferni_2-1703659498488.png

    vjefferni_3-1703659687744.png

     

    Best regards,

  • sachk_1 Profile Picture
    sachk_1 31 on at
    Re: Update SharePoint Online library lookup column

    @v-jefferni, I didnt get what you mean. I'm facing another problem is my sharepoint library contains more than 100k items.

    Actually what needed is get rows from sql table then using flow just checked the "name" column in sharepoint online library and if found the matching row then need to update the fields from sql record.

    Can you help?

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint Online library lookup column

    Hi @sachk_1 ,

     

    As what it's saying in the link I posted previously, you need to use Get items actions as many times as the LookUp columns. After getting the row ID from source lists, set it in LookUp fields of the Update item action.

     

    So, for each SQL row, get Type1 LookUp column ID value from source list1 based on SQL Type1 texts, Type2 and 3 columns are the same, then in Update item action, use the three ID numbers to populate Type1/2/3 Id fields.

     

    Best regards,

  • sachk_1 Profile Picture
    sachk_1 31 on at
    Re: Update SharePoint Online library lookup column

    @v-jefferni, I'm stuck with updating values to lookup columns. Can you help?

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint Online library lookup column

    Hi @sachk_1 ,

     

    At what point did you get stuck? 

     

    Best regards,

  • sachk_1 Profile Picture
    sachk_1 31 on at
    Re: Update SharePoint Online library lookup column

    Hi @v-jefferni ,

     

    Thank you for reply. Here it works like this. As this is a SharePoint library there is a PDF. PDF name is same as Name column in SQL table. So through the flow need to get rows from SQL and then look for each file and then update the remaining field columns in SharePoint. No create item used.

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Update SharePoint Online library lookup column

    Hi @sachk_1 ,

     

    To update SharePoint LookUp columns, you will need to get the source list item ID. In summary, for each item in SQL, you need Get items action to get the specific item ID from source list using Filter query, then use the found ID in LookUp input field in Create item action.

    Solved: How do I fill a Sharepoint Lookup Column in Power ... - Power Platform Community (microsoft.com)

     

    Best regards,

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard