cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Alexandre-Viana
Level: Powered On

Add data to excel sheet by button press.

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Add data to excel sheet by button press.

Hi @Alexandre-Viana ,

 

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Add data to excel sheet by button press.

Hi @Alexandre-Viana ,

 

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Alexandre-Viana
Level: Powered On

Re: Add data to excel sheet by button press.

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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 54 members 4,581 guests
Please welcome our newest community members: