Announcements
Hello Powerapps Community,How do I setup patch function in powerapps? I would like to trigger patch function to get the email, username and time in an excel sheet?
Hello @IshanVats
Does this official video and the documentation help?
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
So on create a button and name it For ex. Send
OnSelect event you can capture the email address using User().Email and save it in a sharepoint list or you can store that in a excel.
You need to connect your app to an excel sheet and everytime someone clicks on send button you need to save that excel sheet with User().Email.
1. Create an excel in onedrive with these columns User Name, Email, Time
2. Once you create the columns in excel you also need to Select your columns and one row and then create that as a table in excel. Give a name to your table. Table2 - Name of the table in excel
3. Now connect to this excel through OneDrive connector in PowerApps and choose the table you created.
4. On your send button you need to write this code Patch( Table2, Defaults(Table2), { 'User Name': User().FullName, Email: User().Email, Time: Now() } )
Every time user clicks on send button it should log an entry with user details and time as well
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 955
11manish 652
Valantis 626
