Answered

How to use With and Search function with an If condition

(0) Share

Report

Posted on by indhaa

Hi,

I'm trying to use the Search using the With as given in this blog https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/With-Statement-to-include-non-Delegable-filters/ba-p/660997 by @WarrenBelz .

Having some issue since my Filter will change based on User . How to add the If condition to change the Filter

If
(
 selectedNavItem = 2,
 SortByColumns(
 Filter(
 SPLIST, 
 RequesterDepartment=LogInUserDept),
 StartsWith(RequestTitle, searchInput.Text) || 
 StartsWith(RequesterFullName, searchInput.Text) || 
 IsBlank(searchInput.Text)),
 "ID", Descending),
 
 	selectedNavItem = 3, 
	 SortByColumns( 
	 Filter(
 SPLIST, 
 RequesterEmail=LogInUserMail,
 StartsWith(RequestTitle, searchInput.Text)|| 
 IsBlank(searchInput.Text)), 
	 "ID", Descending) 
	 
)

I tried adding like below and I know it is not correct.

With(
 If(selectedNavItem = 2,
 {
 MyFilter: 
 Filter(
 SPList,
 Department=LogInUserDept),
 
	},
	selectedNavItem = 3,
	{
 MyFilter: 
 Filter(
 SPList,
 Email=LogInUserMail),
 
	}
	),	
	
 Search(
 MyFilter,
 searchInput.Text,
 "FullName",
	 "Title"
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @indhaa .

I am assuming the only choices for selectedNavItem are 2 and 3?

With( { MyFilter: Filter( SPList, If( selectedNavItem = 2, Department=LogInUserDept, Email=LogInUserMail ) ) }, Search( MyFilter, searchInput.Text, "FullName", "Title" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

I'm getting delegation warning on it.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@indhaa ,

A step back

With( { MyFilter: If( selectedNavItem = 2, Filter( SPList, Department=LogInUserDept ), Filter( SPList, Email=LogInUserMail ) ) }, Search( MyFilter, searchInput.Text, "FullName", "Title" ) )

You are also going to have to accept at times that you simply cannot do everything you want to do in a Delegable manner.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
indhaa on at

Like
a
(0)

Report
Copy link

Link copied!

Yah, I don't think I will be able to use it.

Your above code is delegable but I need to add more condition which will not be delegable, so going to stick with my old code.

Thanks for the help

Was this reply helpful? Yes No