cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhinesh28R
Post Prodigy
Post Prodigy

Powerapps Excel data source lookup values

Hi all,

 

In my app am using a excel as a data source.

Now i have a doubt on this.

How to we get a value on a other spreadsheet like a SharePoint list lookup field column?

This is what i need to know.

 

Thanks,

Dhinesh

 

 

 

1 REPLY 1
v-jefferni
Community Support
Community Support

Hi @Dhinesh28R ,

 

Could you please share more details about your scenario? What is the relationship between the two tables?

 

In short words, with Excel as the data source you will need a key column value to connect the two tables, similar to in SQL. For example, assume you have an ID column as the key column of table1 and values are distinct, in table 2 you could use a tabel1ID column to store the table1 ID value. In this way, like in SharePoint you will have a LookUp column tabel1ID in table2 which looks up to table1.

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,294)