Notifications
Announcements
Hard to a describe so here is the Code:
If( IsBlank(First(Filter(Source, ID = ThisItem.ID)).Value), "", First(Filter(Source, ID = ThisItem.ID)).Value )
Do I really need to use the Filter twice or am I missing something?
Thank you
@KRider
Coalesce(LookUp(Source, ID = ThisItem.ID).Value) //This function will return a blank if the result of the LookUp is blank) otherwise the value of the LookUp will be returned.
Also, this may work even simpler:
Coalesce(First(Filter(Source, ID = ThisItem.ID)).Value, "")
@RonLar
Mine is even more concise.
LookUp takes a bit more resource than Filter no?
Nope http://powerappsguide.com/blog/post/performance-why-is-lookup-better-than-firstfilter#:~:text=Two%20popular%20ways%20to%20retrieve%20a%20single%20record,it%27s%20better%20to%20call%20LookUp%2C%20compared%20to%20First%2FFilter.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 711 Most Valuable Professional
Michael E. Gernaey 319 Super User 2025 Season 2
Power Platform 1919 268
