Answered

Filter Users with an Icon

(0) Share

Report

Posted on by IzabEwa

159

I have an app with a gallery view. When the user open the app, they can see all the entries but Id like to them to be able to press an icon and then they can only see their own entries.

I have this in Items for gallery:

Sort(Filter('Timeopgørelse samt kilometer - prototype';Author.Email=User().Email); Dato ;Descending)

How do I make an icon perform that?
And then possibly have a second icon that brings back the original view?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @IzabEwa

Icon Onselect
UpdateContext({IsAll: !IsAll})

Filter condition based on current user

With( {sData: IssueTracker}, If( IsAll, Filter( sData, 'Assigned to'.Email = User().Email ) ) )

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

Like
a
(0)

Report
Copy link

Link copied!

@IzabEwa

Icon OnSelect

Set( vUser; !vUser)

Gallery Items

If( vUser;

// Show users items

Sort(Filter('Timeopgørelse samt kilometer - prototype';Author.Email=User().Email); Dato ;Descending);

// else show all items

Sort('Timeopgørelse samt kilometer - prototype'; Dato ;Descending)

)

Was this reply helpful? Yes No
IzabEwa 159 on at

Like
a
(0)

Report
Copy link

Link copied!

what does wCode stand for here?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Just a variable.

Was this reply helpful? Yes No
IzabEwa 159 on at

Like
a
(0)

Report
Copy link

Link copied!

// else show all items
Sort('Timeopgørelse samt kilometer - prototype'; Dato ;Descending)
)
I dont need to include this part right ?

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
My bad, Here is get all if not
With( {wCode: IssueTracker}, If( IsAll, Filter( wCode, 'Assigned to'.Email = User().Email ),wCode ) )

Was this reply helpful? Yes No
IzabEwa 159 on at

Like
a
(0)

Report
Copy link

Link copied!

would you mind explaining your notation ?

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

Like
a
(0)

Report
Copy link

Link copied!

Yes, if you want to toggle between ALL items and USER items

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Icon
Icon switches from ON to Off or Off to ON

Filter
Bind Source to variable wCode
If toggle selected, filter it. if not bring all
Finally sort the result
With( {wCode: IssueTracker}, Sort( If( IsAll, Filter( wCode, 'Assigned to'.Email = User().Email ), wCode ), Created, Descending ) )

Was this reply helpful? Yes No
IzabEwa 159 on at

Like
a
(0)

Report
Copy link

Link copied!

yes i meant that i dont repeat it again , so the code doesnt end up looking :
If(vUser; Sort(Filter('Timeopgørelse samt kilometer - prototype';Author.Email=User().Email); Dato ;Descending)Sort('Timeopgørelse samt kilometer - prototype'; Dato ;Descending))

Was this reply helpful? Yes No