Using Patch Formula

(0) Share

Report

Posted on by kasfour

104

Hello,

I am new to this, and I would like to use the Patch formula to save data inserted into the shown Text Inputs.

I used the below formula, but I am facing an issue with the column types (Person or Group and Number )

Patch('Emp.Resign-List', Defaults( 'Emp.Resign-List' ),
{RequiredStatus:Dropdown3.Selected.Value,
HITSID:HITSIDinput.Text, Name:NAMEinput.Text, Campaign_x002f_Dept_x002e_:CAMPAIGNinput, AccountMgr_x002e__x002f_Head:MGRinput.Text})

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

oappdev 901 on at

Like (0)

Report
Copy link

Link copied!
Hello @kasfour
Try the following formula to patch (Person or Group and Number)
Number column:
{Campaign_x002f_Dept_x002e_:Value(Campaign_Number.Text)}

Person or Group:
{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName:User().FullName, Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"", Email:User().Email, JobTitle:"", Picture:"" }

Let me know if that helps.

Was this reply helpful? Yes No
kasfour 104 on at

Like (0)

Report
Copy link

Link copied!

I dont get the Person or Group part. Where should I add the AccountMgr_x002e__x002f_Head:MGRinput.Text, part to locate where the data would be saved in the ShP list?

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!

Let's resolve one thing at a time. Is AccountMgr_x002e__x002f_Head:MGRinput.Text a number column? Also, can you post your Patch formula?

Was this reply helpful? Yes No
kasfour 104 on at

Like (0)

Report
Copy link

Link copied!

Formula is :
Patch('Emp.Resign-List', Defaults( 'Emp.Resign-List' ),
{RequiredStatus:Dropdown3.Selected.Value,
HITSID:HITSIDinput.Text, Name:NAMEinput.Text, Campaign_x002f_Dept_x002e_:CAMPAIGNinput, AccountMgr_x002e__x002f_Head:MGRinput.Text})

Where
RequiredStatus: is a dropdown
HITSID: is a Number
Name: is a Text
Campaign_x002f_Dept_x002e: is a text
AccountMgr_x002e__x002f_Head: is a Person or Group

What I am trying to do is have an empty table (same as on the ShP list) for users to add the data on, and after clicking on Save Button, this data gets saved on the List.

Thank you for your help.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!
You're very welcome.

Okay, try the following Patch Formula. Let me know if it patches the (HITSID) number column for you. Working on the Person or Group column for you next.

Patch ( 'Emp.Resign-List', Defaults('Emp.Resign-List), {RequiredStatus:Dropdown3.Selected.Value}, {ITSID:Value(HITSIDinput.Text)}, {Name:NAMEinput.Text}, {Campaign_x002f_Dept_x002e_:CAMPAIGNinput}, )

Was this reply helpful? Yes No
kasfour 104 on at

Like (0)

Report
Copy link

Link copied!

I tried the mentioned formula and this error appeared.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!
I see what is wrong. Try this formula. My fault.
Patch ( 'Emp.Resign-List', Defaults('Emp.Resign-List), {RequiredStatus:Dropdown3.Selected.Value}, {ITSID:Value(HITSIDinput.Text)}, {Name:NAMEinput.Text}, {Campaign_x002f_Dept_x002e_:CAMPAIGNinput} )

Was this reply helpful? Yes No
kasfour 104 on at

Like (0)

Report
Copy link

Link copied!

I dont get whats the last comma for?. I tried it and this is the error now.
Thank you so much for your patience here

Was this reply helpful? Yes No
kasfour 104 on at

Like (0)

Report
Copy link

Link copied!

I even tried this one:

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
Copy link

Link copied!
No worries 😀. We will get this working.

Let's try a simple approach. If it works then you can add the rest of the columns to the formula.
Patch ( 'Emp.Resign-List', Defaults('Emp.Resign-List'), {RequiredStatus:Dropdown3.Selected.Value} )

Keep me posted.

Was this reply helpful? Yes No