Answered

PowerApps If Lookup Empty then display a message

(0) Share

Report

Posted on by PowerUser39

Hello,

I am working on an app where I have a lookup function on a text input box to exactly look and match the co-ordinates of a location in the SharePoint list and display the Title of the co-ordinates and the below function is getting the value perfectly.

LookUp('SharePoint List',field_1 = Location.Latitude && field_2 = Location.Longitude).Title

Now what I want is that to display a message "You are not at a Station" on the same text box if the co-ordinates doesn't match any record. How can I achieve this? I tried If, Lookup with Is Empty and also Isblank but it is throwing error.

Please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PowerUser39,

We can check whether the LookUp is blank and conditionally display a text value:

With( //Temp save record to a function variable { wRecord: LookUp( 'SharePoint List', field_1 = Location.Latitude && field_2 = Location.Longitude ) }, //Display the first value that is not blank Coalesce(wRecord.Title, "You are not at a Station") )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
PowerUser39 73 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @LaurensM It worked 🙂

Was this reply helpful? Yes No
PowerUser39 73 on at

Like
a
(0)

Report
Copy link

Link copied!

@LaurensM Need your help again. I trimmed your solution to replace selected text from gallery list and current code is below.

If(
IsBlank(SelectedLocation),
With(
{
wRecord:
LookUp(
'SharePoint List',
field_1 = Location.Latitude && field_2 = Location.Longitude
)
},
Coalesce(
wRecord.Title,
"You are not at a Substation"
)
),
SelectedLocation
)

The above solution checks whether the Lookup is blank and displays a text value inside the same Textbox and also adds the selected value from Gallery list. Now what I want is that to display the conditional text as a notification rather displaying it inside the textbox. How to do this?

The below is the one I have but not sure how to include this in the above code?

If(
!IsBlank(SubstationInput.Text),
Notify("You are not at a Substation. Please click the location icon next to Substation Textbox and choose your Station.",NotificationType.Information)
).

I tried including the above If in the original If statement but throwing error.

Was this reply helpful? Yes No