Powerapps Excel data source lookup values

[Dhinesh28R]

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

[v-jefferni]

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.