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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,433)