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

)

All responses (6)

Answers (0)

Yogesh Murugan 443 Super User 2025 Season 1 on at

Like (0)

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

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
Nehal3 32 on at

Like (0)

Report

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

Hi, it's attached.

Capture_App.JPG
Yogesh Murugan 443 Super User 2025 Season 1 on at

Like (0)

Report

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

Can you send screen shot and code ?
Nehal3 32 on at

Like (0)

Report

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

Hi, it's the same thing with that code too. No errors but shows a blank gallery
Yogesh Murugan 443 Super User 2025 Season 1 on at

Like (0)

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

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) ) )
Nehal3 32 on at

Like (0)

Report

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

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