Unanswered

What is wrong with this code? Filtering inside an IF statement

(0) Share

Report

Posted on by Nehal3

Hi,

I'm not sure what's wrong with this statement. It creates neither an error nor shows any sharepoint records in the gallery? I put the code inside the Items property of my gallery. 'Search Box'.Text is the text input field and I want to filter only if it's empty (and display the entire sharepoint list if not). Can someone please help me?

If (

!IsBlank('Search Box'.Text),

Filter(

DWBExtractMigrationv1162,

StartsWith(

"EDG-ID", Value('Search Box'.Text)) ||

StartsWith(

"RequestStatus", 'Search Box'.Text

) ||

StartsWith(

"RequestType", 'Search Box'.Text)||

StartsWith(

"Title", 'Search Box'.Text)

), DWBExtractMigrationv1162

)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Nehal3 32 on at

Like
a
(0)

Report
Copy link

Link copied!

I meant I want to filter it if the text box is not empty and show the entire list if it is empty!

Was this reply helpful? Yes No
Yogesh Murugan 451 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this code :
If( IsBlank('Search Box'.Text), DWBExtractMigrationv1162, Filter( DWBExtractMigrationv1162, StartsWith("EDG-ID", 'Search Box'.Text) || StartsWith("RequestStatus", 'Search Box'.Text) || StartsWith("RequestType", 'Search Box'.Text) || StartsWith("Title", 'Search Box'.Text) ) )

Was this reply helpful? Yes No
Nehal3 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, it's the same thing with that code too. No errors but shows a blank gallery

Was this reply helpful? Yes No
Yogesh Murugan 451 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you send screen shot and code ?

Was this reply helpful? Yes No
Nehal3 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, it's attached.

Was this reply helpful? Yes No
Yogesh Murugan 451 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this
If( IsBlank(Trim('Search Box'.Text)), DWBExtractMigrationv1162, Filter( DWBExtractMigrationv1162, StartsWith("EDG-ID", 'Search Box'.Text) || StartsWith("RequestStatus", 'Search Box'.Text) || StartsWith("RequestType", 'Search Box'.Text) || StartsWith("Title", 'Search Box'.Text) ) )
If is not search is not blank is filtered correct

Was this reply helpful? Yes No