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
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.
LookUp takes a bit more resource than Filter no?
@RonLar
Mine is even more concise.
Also, this may work even simpler:
Coalesce(First(Filter(Source, ID = ThisItem.ID)).Value, "")
@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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Ragavendar Swaminatha Subramanian as our September…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 917 Most Valuable Professional
Michael E. Gernaey 387 Super User 2025 Season 2
MS.Ragavendar 334 Super User 2025 Season 2
