web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Adding Condition to Se...

Power Apps

Answered

Adding Condition to Search Function

(0) Share

Report

Report

Posted on by simms7400

829

HI Folks -

I have a the following syntax which is working great:

Search(rdAssets,"PFC-" & Right(Left(DataCardValue43.Text,9),5),"Name")

However, I want to add a condition to that it does the aforementioend search AND search the "Partnered" column for "Yes".

I'm unable to get my rendition to work, can anyone assist? Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

simms7400 829 on at

Like
a
(0)

Report
Copy link

Link copied!
OKay, I made some progress...This seems to work:
If( CountRows( Filter( rdAssets, "PFC-" & Right(Left(DataCardValue43.Text,9),5) in 'Name', Len(PartnershipID)>0 ) ) > 0, "yes","no" )

Just a question, does that syntax act as an "AND", rather than two separate searches? Also, is Len the est practice way of checking if a field is null? Thanks!

Was this reply helpful? Yes No
alrezac Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Looking through our documentation it seems like "len" should be fine for what you are doing. The "and" operator is just adding a 2nd filter to the search overall it shouldn't be doing two searches. If you want to take a look and learn more I'll include a link below.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation