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

Unanswered

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

SpongYe 5,603 Super User 2025 Season 2 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
WarrenBelz 153,042 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No

Join the conversation