Hello,
I have four columns in a excel sheet and actually need to add one more for the user who is filling out a form and submit it.
How can I read the username respectively and/or the users email and fill it into the same row which is created after click on submit button with SubmitForm(Form1) function?
Thank you very much in advance.
Best.
Hi @Applicable88,
Do you want to save the creator to the excel sheet?
First of all, you should add a new column where you save the creator within the Excel table, then you should set the TextInput Default property using the User().Email or User().DisplayName.
Remember to refresh the data source after you add the new column to your excel table, and add the new added field to your form so that you could get a TextInput control by default.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2