web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApp lookup value ...

Power Apps

Answered

PowerApp lookup value from SharePoint List

(0) Share

Report

Report

Posted on by Mclean2023

79

Hi All,

I have an app that has a lookup field that i want to have look up another field if the first is blank.

Output has the lookup code in it as LookUp('Tracker','Request ID'=Lookup Value 1.Text,OUtput A)

LookUp('Tracker','Request ID'=Lookup Value 1.Text,OUtput A) if Lookup Value 1 is blank LookUp('Tracker','Request ID2'=Lookup Value 2.Text,OUtput A).

So two fields to lookup from and output either into the output field

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mclean2023

You code should look like:
If( CountRows(LookUp('Tracker','Request ID'=Lookup Value 1.Text,Output A)) > 0, LookUp('Tracker','Request ID'=Lookup Value 1.Text,Output A), LookUp('Tracker','Request ID2'=Lookup Value 2.Text,OUtput A) )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mclean2023 ,

Try this format

With( { _Data: Coalesce( 'Lookup Value 1'.Text, 'Lookup Value 2'.Text ) }, LookUp( 'Tracker', 'Request ID' = _Data ).OutputA )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Join the conversation