Answered

Following tutorials but code has changed so form shows so many errors, i need help

(0) Share

Report

Posted on by Mpowis

I have been learning Power Apps and following some videos YouTube but it seems the code has changed because i cannot recreate their results.

I have a list on SharePoint, i then created an app linked to it in power apps as a gallery, i got the data inputting into text boxes from the list, i then added an edit icon and set it so when the edit icon is clicked it will edit that record using the ID, that all works fine but when i add a save icon i start to get invalid arguments.

Code for edit

If(ThisItem.ID=EditMode,false,true)

Code for Text boxes (DisplayMode)

If(ThisItem.ID=EditMode,DisplayMode.Edit,DisplayMode.View)

Code for Save

UpdateContext({EditMode: ""}); Patch('Petty Cash Reimbursement',{ID=ThisItem.ID},{Description:In_Desc.Text,Students:In_Stu.Number,Staff:In_Staff.Number,'Cost Per Head': In_Cost.Number,Value:In_Val.Number,'Claimant Signature':In_C_Sign.Text,'Manager Signature':In_M_Sign.Text,Code:In_Code.Number})

As soon as i enter the code for Save the formulas error out saying Invalid argument type with the text inputs and Unexpected characters we expect an operator such as +,*'or & at this point in the formula.

thanks for your help... Power Apps Newbie

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!
Please try it with this small change in your Patch - {ID: ThisItem.ID}

UpdateContext({EditMode: ""}); Patch('Petty Cash Reimbursement',{ID: ThisItem.ID},{Description:In_Desc.Text,Students:In_Stu.Number,Staff:In_Staff.Number,'Cost Per Head': In_Cost.Number,Value:In_Val.Number,'Claimant Signature':In_C_Sign.Text,'Manager Signature':In_M_Sign.Text,Code:In_Code.Number})

Regards,
Pat

Was this reply helpful? Yes No
Mpowis 49 on at

Like (0)

Report
Copy link

Link copied!

@mahoneypat sorry that change didn't work still as many errors

Was this reply helpful? Yes No
timl 37,210 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Mpowis

Assuming that the save button should update the current record in the gallery, this is the formula that you should use.

Patch('Petty Cash Reimbursement', LookUp(ID=ThisItem.ID), {Description:In_Desc.Text,Students:In_Stu.Text, Staff:In_Staff.Text,'Cost Per Head': In_Cost.Text, Value:In_Val.Text,'Claimant Signature':In_C_Sign.Text, 'Manager Signature':In_M_Sign.Text, Code:In_Code.Text} )

The patch function takes three arguments - the data source, the record to update, and the record details.

To specify the record that you want to update, we would call the lookup function.

Also, assuming that the controls that you specify such as In_Stu are text input controls, there is no such property as Number. If you want to retrieve a numeric value, you would need to refer to the value function: eg, Value(In_Stu.Text)

Was this reply helpful? Yes No
Verified answer

Mpowis 49 on at

Like (0)

Report
Copy link

Link copied!
You were so close, after more research and looking at your answer i tried the code many different ways and the one that finally worked was this:

pdateContext(Patch('Petty Cash Reimbursement',ThisItem,{Description:In_Desc.Text,Students:Value(In_Stu.Text),Staff:Value(In_Staff.Text),Value:Value(In_Val.Text),'Claimant Signature':In_C_Sign.Text,'Manager Signature':In_M_Sign.Text,Code:Value(In_Code.Text)}))
It may not be pretty but it works lol

Was this reply helpful? Yes No