Do If statements with Filters always need that second Filter to show information?

Like (0) Share

Report

Posted on 16 Nov 2022 20:08:45 by KRider

577 Super User 2024 Season 1

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

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on 16 Nov 2022 at 20:34:11

Like (1)

Report
Re: Do If statements with Filters always need that second Filter to show information?

@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.

Was this reply helpful? Yes No
RonLar 60 on 16 Nov 2022 at 20:43:02

Like (1)

Report
Re: Do If statements with Filters always need that second Filter to show information?

Also, this may work even simpler:
Coalesce(First(Filter(Source, ID = ThisItem.ID)).Value, "")

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on 16 Nov 2022 at 20:44:40

Like (0)

Report

Re: Do If statements with Filters always need that second Filter to show information?

@RonLar

Mine is even more concise.

Was this reply helpful? Yes No
KRider 577 Super User 2024 Season 1 on 18 Nov 2022 at 13:12:41

Like (0)

Report

Re: Do If statements with Filters always need that second Filter to show information?

LookUp takes a bit more resource than Filter no?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on 18 Nov 2022 at 14:05:53

Like (1)

Report

Re: Do If statements with Filters always need that second Filter to show information?

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.

Was this reply helpful? Yes No