cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Post Patron
Post Patron

Create a button to display all the expense reports that the connected person has created

Hello, I have a Sharepoint "Notes de frais" list and I would like to create a Power Apps application allowing managers in my company to create expense reports for company employees.
I would like to create a Power Apps application where on this page

s44_0-1641987879360.png

 

there is a button (located somewhere on the red banner for example) which allows, when we click on it, to display all the expense reports that the connected manager has created.

 

I tried this but it doesn't work:

Filter('Notes de frais';User().Email=BrowseGallery1.Selected.'Créé par'.Email)

s44_0-1642067087862.png

 

when I connect to the account of a person who has not created any expense report, when I click on the button I still see all the expense reports. While normally it's supposed to show none since I logged in with an account that didn't create any expense reports.

s44_1-1642067187936.png

 

 

Could you help me please? Thanks in advance !

 

 

 

 

My sharepoint list : s44_1-1641214922274.png

 

15 REPLIES 15

@Nogueira1306  I have already this in my BrowserGallery and I need it 😧

s44_1-1642078232499.png

 

If( varFilter = false;
WHAT YOU HAVE; //PUT THERE WHAT YOU HAVE WRITE NOW
Filter('Notes de frais';'Créé par'.Email = User().Email) // PUT HERE WHAT YOU WANT TO FILTER WHEN YOU PRESS THE BUTTON
)

Thank you very much ! But varFilter is not recognized @Nogueira1306 

s44_0-1642158170187.png

 

Did you write on app OnStart:

Set(varFilter; false)

AND 

 

On Button OnSelect:

 

Set(varFilter; true)


???

Finally it's work, thank you so much for your great help ! 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,615)