You’re offline. This is a read only version of the page.
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
Hi @Mclean2023 ,
Try this format
Share
Report
All responses (
Answers (
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
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.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
