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!
This is perfect! Thank You!
Just make sure Title is a text value, anything included like:
{
Title: "ATextValue",
Manager: User().FullName,
'Manager Email': User().Email,
Time: Now()
}
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.(...) ?
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.
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.
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()
}
)
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.
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.
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.
Hi! All of this is very doable! Here is a brief summary of the main steps you'll need to do
Form:
Submit Button:
Additional documentation for Forms
Hope this helps!
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional