web

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

News and Announcements icon

Power Platform CommunityForums Power Apps If LookUp collection e...

Power Apps

Answered

If LookUp collection exist then, else

(0) Share

Report

Report

Posted on by Theuserprofil

6

Hi, this is annoying me for a while now. Believes that this my formula can be simpler. But can not figure it out.

What I want:

If the item exist in collections, then show name, if not show room number.

My formula, that works.

If(CountRows(Filter(List,OfficeLocation = "C109")) > 0,LookUp(List,OfficeLocation = "C109",Name),"C109")

Thanks, for any help.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Theuserprofil

Please consider changing your Formula to the following:

Coalesce(LookUp(List, OfficeLocation = "C109", Name), "C109")

I hope this is helpful for you.

Was this reply helpful? Yes No
Theuserprofil 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much, I thought it was a better solution. 🙂

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Theuserprofil

The Coalesce function is a very helpful one!!

Was this reply helpful? Yes No

Join the conversation