Populating list cells that are using look up function

[Mojpage]

Hello,

I'm part of a team looking to upload lots of data into a List to use in PowerBI. The flow works in taking the data from Excel and populating the List except for a column that's uses the look up feature. These cells have remained empty, though the data has gone on to another archive excel sheet, so I know the data is collected, which leads me to think it must be something to do with this column using this feature.

Any advice on this would be appreciated.

[DiegoEscobar2 · Accepted solution]

Hi @Mojpage . The thing is that Lookup columns are referenced by the Id that is an integer. You first must find the Id from the lookup table that matches the "option name". 

Here are screenshots from a flow that I tested OK:

Hope this help, and if this is the case, please mark it as a solution!

Cheers!

Diego.