Filter Gallery

(0) Share

Report

Posted on by codeworks

321

Hi everyone,

I want to filter this gallery based on user accessing the dashboard and the corresponding ApproverID . My code below

With(
{
myApprovalList: LookUp(
'SFA Leave Approvers',
ASM = varUserEmail || Sops = varUserEmail
).ApproverID
},
SortByColumns(
Filter(
'SFA Leave Request',
FormStatus = "Awaiting Automation Support Manager" && ApproverID = myApprovalList || FormStatus = "Awaiting Sales Operations" && ApproverID = myApprovalList,
StartsWith(
'Name of User',
TextSearchBox1_1.Text
)
),
"ID",
If(
SortDescending1,
SortOrder.Descending,
SortOrder.Ascending
)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @codeworks ,

A bit hard without knowing your exact logic, but your And/Or needed bracketing and I do not think you need the Or

With( { myApprovalList: LookUp( 'SFA Leave Approvers', ASM = varUserEmail || Sops = varUserEmail ).ApproverID }, SortByColumns( Filter( 'SFA Leave Request', FormStatus = "Awaiting Automation Support Manager" && FormStatus = "Awaiting Sales Operations" && ApproverID = myApprovalList && StartsWith( 'Name of User', TextSearchBox1_1.Text ) ), "ID", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
codeworks 321 on at

Like (0)

Report
Copy link

Link copied!

I have to lists
List 1.
FormStatus
ApproverID

List 2
ASM
Sops
ApproverID

I want ASM to only see what has Form Status as Awaiting Automation Manager Support and Sales Ops to see what has Form Status as Awaiting Sales Operations.

the problem I am having with my logic is both ASM and Sops is seeing what belongs to two of them at the same time

Was this reply helpful? Yes No