How to use LOOKUP function on multiple excel files (2)

(0) Share

Report

Posted on by JoshL5

Hi, is it possible to use LOOKUP function on multiple excel files (2)?

If not, would an IF statement work? Like LOOKUP this file and if not found lookup in this other file?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it possible to do Lookup on multiple columns. Can you give example of what you want to achieve.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JoshL5

Sure, something like this in the Items property of a gallery.

If( !IsBlank(Lookup(Table1,Title-TextInput1.Text), Lookup(Table1, Title=TextInput1.Text), !IsBlank(Lookup(Table2,Title-TextInput1.Text), Lookup(Table2, Title=TextInput1.Text), !IsBlank(Lookup(Table3,Title-TextInput1.Text), Lookup(Table3, Title=TextInput1.Text), etc. )

The formula above will search through tables starting with table 1 until it finds an item that matches the condition. It will stop once an item is found.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JoshL5 ,

Could you please show more details about your scenario?

Do you want to apply the LookUp function to multiple Excel tables? Do these multiple Excel table have same data structure?

Regarding the needs that you mentioned, I think your thought is in right direction. The If function could achieve your needs. On your side, you could choose different Excel table as the first argument in the LookUp function against different conditions.

The sample formula may looks as below:

LookUp( If( // choose different data source based on differnt condition DataSourceOption = "Option1", Table1, DataSourceOption = "Option2", Table2, DataSourceOption = "Option3", Table3 ), FilteredColumn = "xxxxx" )

Please try above solution, hope it could solve your problem.

Regards,
JoshL5 2 on at

Like
a
(0)

Report
Copy link

Link copied!

this should meet my need thanks!

@v-xida-msft