So i have a listing of costumers , that is imported from a excel in my one drive. So i have a field on the excel called "CHECK IN" wich is blank , and i need that when the costumer arrives i press the button and it types "Checked" into the cell in the excel. The problem is it has to be peer costumer , so i have to have some kind of variable that identifies who is checking in , so that power apps knows where to add the "Checked" text.
Solved! Go to Solution.
Hi @Anonymous ,
You can use User function to check the current user's email. Formula could be some thing like:
If(User().Email="xxx",Patch(Table,Defaults(Table),{Title1:"Checked"}),User().Email="yyy",Patch(Table,Defaults(Table),{Title2:"Checked"}))
Regards,
Mona
Hi @Anonymous ,
You can use User function to check the current user's email. Formula could be some thing like:
If(User().Email="xxx",Patch(Table,Defaults(Table),{Title1:"Checked"}),User().Email="yyy",Patch(Table,Defaults(Table),{Title2:"Checked"}))
Regards,
Mona
Thanks! i found the Patch function and used it like this:
" Patch(Teste;ThisItem;{'Checked?': "Checked-In"}) "
Was simple as that , but i didn´t know the Patch function!
Thanks non the less.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
208 | |
189 | |
83 | |
57 | |
36 |
User | Count |
---|---|
296 | |
246 | |
119 | |
83 | |
55 |