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
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)
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.
Could you help me please? Thanks in advance !
My sharepoint list :
Solved! Go to Solution.
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
)
Try this:
Filter('Notes de frais';'Créé par'.Email=BrowseGallery1.Selected.'Créé par'.Email)
That will filter your 2º gallery by Created By. So, imagine, tha tyou pick something created by you on browseGallery1. I twill only show items create by you on the seconde one.
To fitler a gallery by User().Email try this:
Filter('Notes de frais';'Créé par'.Email = User().Email)
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!
Last Post on Community
My website!
Instead of Created By field use the field that you creaetd "Nom Prenom"
That means that the filter failed, the query failed
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!
Last Post on Community
My website!
@Nogueira1306 How so ? Can you write me the line I should put please? I don't think I understood what you meant :0
Filter('Notes de frais';'Nom Prom'.Email=BrowseGallery1.Selected.'Nom Prom'.Email)
@Nogueira1306 Using this formula, when I click on the button nothing happens now 😞
My msitake. Because I only underssod now that you want to filter when you click a button...
So, on app Start, write this:
Set(varFilter; false)
On Button, OnSelect:
Set(varFilter; true)
On gallery write this:
If( varFilter = false;
'Notes de frais'; //IT SHOWS EVERYTHING
Filter('Notes de frais';'Créé par'.Email = User().Email)
)
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!
Last Post on Community
My website!
Thank you ! But can you show me where are OnGallery and On app Start please :0 ? I'm new to Power
Apps >< @Nogueira1306
Gallery:
App OnStart:
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!
Best regards,
Gonçalo Nogueira
Check my LinkedIn!
Check my User Group (pt-PT)!
Last Post on Community
My website!
User | Count |
---|---|
259 | |
111 | |
97 | |
48 | |
41 |