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
@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?
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,
@v-jefferni, I'm stuck with updating values to lookup columns. Can you help?
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.
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.
Best regards,