Update SharePoint Online library lookup column

(0) Share

Report

Posted on by sachk_1

Hi,

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

SQL table as follows,

Name

Type 1

Type 2

Type 3

Date

Country

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:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
sachk_1 31 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

Hi @sachk_1 ,

At what point did you get stuck?

Best regards,

Was this reply helpful? Yes No
sachk_1 31 on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
sachk_1 31 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sachk_1 ,

Please check the flow I created using your logic:

Best regards,

Was this reply helpful? Yes No