cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
s44
Super User
Super User

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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,709)