cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mojpage
Helper I
Helper I

Populating list cells that are using look up function

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.

1 ACCEPTED SOLUTION

Accepted Solutions
DiegoEscobar2
Helper II
Helper II

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:

 

DiegoEscobar2_3-1664380217426.png

 

DiegoEscobar2_4-1664380260301.png

DiegoEscobar2_6-1664380469316.png

 

DiegoEscobar2_7-1664380538859.png

 

 

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

Cheers!

Diego.

View solution in original post

1 REPLY 1
DiegoEscobar2
Helper II
Helper II

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:

 

DiegoEscobar2_3-1664380217426.png

 

DiegoEscobar2_4-1664380260301.png

DiegoEscobar2_6-1664380469316.png

 

DiegoEscobar2_7-1664380538859.png

 

 

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

Cheers!

Diego.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,411)