So I have an existing SharePoint list which contains a column that holds a special ID. I have an excel sheet that has a column whose data is dependent on that ID. ex. If the Id is 1, then the corresponding data is "blue", if the ID is 2, then "red" etc etc. SO I need help creating a flow that will import that column into my SharePoint list, and display the correct data depending on the Id already in the list. I am just being cautious because I don't want to mess everything up, which is why I am asking for advice on how to go about this. Thanks!!
There is no direct connection between excel and flow, we could only integrate with excel table on spreadsheets hosted in SharePoint or OneDrive for Business.
Simple test for your reference:
1.Upload the excel file to SharePoint site document library, then insert table with data which you will include in it.
2.Create a new list called "list326", and create ExcelID and colorcolumn as shown below:
3.Create a flow in this list, use the trigger "When an item is created or modified":
4.Use "List Rows present in a table" action to list rows in table we created in excel file before.
5.Add "Condition" action to compare ID in excel file and ExcelID in SharePoint list.
Note: In this action, remember to add group among different values, full conditions like this:
6.Update the list item based on the value from excel table:
Result for your reference: