Answered

Creating Button to capture Names and Email

(0) Share

Report

Posted on by Dongle12

Hello All!

I created an app that has tasks/to-do's, I would like to implement a button thats called "submit". I would like it to have a function where when the user clicks submit it will capture their name/email and if possible the time it was clicked (the time portion isnt important if its not possible) mainly just name and email is the important part. I want this to be captured onto my sharepoint, I have created 3 coloumns as plain text that say manager, manager email, accepted time. How do i go about making this? any help would be appreciated. Thank You!

Categories:

Building Power Apps

Manager wait.png

I have the same question (0)

All responses (10)

Answers (3)

madlad 2,637 Moderator on at

Like (1)

Report
Hi! All of this is very doable! Here is a brief summary of the main steps you'll need to do
Form:
Firstly, You'll want to connect your SharePoint list to the canvas app if that hasn't been done yet.
Then, create a Edit Form.
Set the datasource as your SP List. Change the Default Mode to New.
Select Edit Fields > Add Field > select your fields.
Then, your form should auto-populate with appropriate question cards for each of these.
You can edit these, but you'll have to select each card, go to Advanced, and unlock the control first.
You likely want to change the Update() of the Time card to be Now()
Submit Button:
Create a button, change the text to "Submit"
Change the OnSelect to SubmitForm(The Name of Your Form)
Also add to the OnSelect ResetForm(The Name of Your Form)
Additional documentation for Forms

Hope this helps!

Was this reply helpful? Yes No
Dongle12 38 on at

Like (0)

Report

Hey, @MAD !

I have a Form (microsoft form) already where the manager will fill out and that info gets put into my SP and then filtered into my app. Do i still need to create a Edit Form in this case? For preference i did not add those criteria in the form as i want to make sure the managers dont delegate their tasks to others so i want to document who clicks on that submit button.

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
I see what you're saying! One thing you could try is using the Patch function. This will allow you to save this info, based on the signed in user's information- they won't even have to enter it anywhere.

If you're updating a record you'll have to specify the record to update as the second field. It sounds like you maybe have a gallery where they will select items to update like this?
If it's a new record you're creating, instead of specifying a record, use Defaults(YourDataSource).
Here is some code similar to what you want:
Patch( *YourDataSource*, Defaults(*YourDataSource*) OR *YourRecordToUpdate*, { Name: User().FullName, Email: User().Email, Time: Now() } )
^Please note, you have to fill in your table's name and column names here.

Was this reply helpful? Yes No
Dongle12 38 on at

Like (0)

Report

@madlad

I understand a bit of this, i apologize as im still learning my way around power apps
I attached where i have added the code to the button. I am still receving errors, "Unexpected Charcters. Charcters are used in the forumla in an unexpected way." . Help!

Based on signed in user is perfect and exactly what i was looking for. In my gallery i have a drop down where its defaulted to "incomplete" they will then change it to "complete" and click submit, from there their signed in info (name/emailed tied to their email account) get put into my sharepoint list columns under manager, manager email, accepted time.

Button.png

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
Your quite close! All that's happening is you have one extra ")";
hopefully this fixes the errors:
Patch( 'TCC Event 1', Defaults('TCC Event 1'), { Manager: User().FullName, 'Manager Email': User.Email, Time: Now() } )

Was this reply helpful? Yes No
Dongle12 38 on at

Like (0)

Report

@madlad

Almost!, i went ahead and fixed that extra ")" issue and it seemed to be okay, once I select the button i get a "Network error when using patch fucntion: Field 'Title' is required.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report

Looks like you have a mandatory field 'Title' in your SP list. I believe it's automatically created and can't be deleted. If it's unimportant to you, just include it in your Patch() with the other fields and put some filler data there to remove this error.
You can also use it for your project if you wanted a main descriptive field for example, but you don't have to.

Was this reply helpful? Yes No
Dongle12 38 on at

Like (0)

Report

@madlad

Its unimportant in this case, would I add this in the fields where manager: user(), etc. are and just input Title: user()? Or would this be inputed after Patch('TCC EVENT 1', Title, Defualts.(...) ?

Was this reply helpful? Yes No
Verified answer

madlad 2,637 Moderator on at

Like (1)

Report
Just make sure Title is a text value, anything included like:

{ Title: "ATextValue", Manager: User().FullName, 'Manager Email': User().Email, Time: Now() }

Was this reply helpful? Yes No
Dongle12 38 on at

Like (0)

Report

This is perfect! Thank You!

Was this reply helpful? Yes No