Answered

Unable to filter gallery by email alongside sortbycolumns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Good Afternoon,

I'm new to Powerapps and have been struggling with getting the Dataverse source template version of the Support Desk Ticket app to filter results down by the user who creates the ticket. I have the ticket entries displaying the email address of the creator using <ThisItem.'Created By'.'Primary Email'>, and it displays the email just fine. I have onstart set to <Set(ThisUser, User().FullName)>, and the code below under Items on my gallery, however it keeps kicking back errors on the entire code.If I remove the last 2 lines the items will display but will not filter. I have absolutely no idea what to do now.

SortByColumns
 (Search(
 [@SupportDeskTickets],
 TextSearchBox1.Text,
 "cre6a_createdby2",
 "cre6a_details",
 "cre6a_hardwaresoftware"
 ),
 "cre6a_createdby2",
 If(
 SortDescending1,
 Descending,
 Ascending
 ))
 And
 (Filter('Primary Email' = User().FullName))

Any help would be greatly appreciated.

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,974 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Like this

SortByColumns( Search( Filter( [@SupportDeskTickets], 'Primary Email' = User().FullName ), TextSearchBox1.Text, "cre6a_createdby2", "cre6a_details", "cre6a_hardwaresoftware" ), "cre6a_createdby2", If( SortDescending1, Descending, 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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz That worked, my code is clear of errors now. Thank you kindly!

Was this reply helpful? Yes No