Using variables in a patch function

(0) Share

Report

Posted on by colbyturybury

363

Below is the setup for my variable. It is placed in the OnSelect of a combo box called "chsHorizRequire" drop down

Set(varHorizontalDatum,(If(
chsHorizRequire.Selected.Value = "City Datum",
"CityDatumDescr",
If(
chsHorizRequire.Selected.Value = "Previous Project Coordinates",
"PreviousProjectCoordinatesDescr",
If(
chsHorizRequire.Selected.Value = "Other",
"OtherHorizontalDatumDescr",
""
)
)
)));

Below is my patch funciton

Patch(SurveyRequest_DB, Defaults(SurveyRequest_DB), { varHorizontalDatum: chsHorizRequire.Selected } )

Placing the "varHorizontalDatum" is throwing the error in the patch function.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,254 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You can't use a variable as a fieldname in a record. The fieldnames need to be literal.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Edit. Didn't realize you were making the field name a variable, like previous poster said that isn't possbile

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@colbyturybury If SurveyRequest_DB is the data source that u'r patching, where varHorizontalDatum is you need to replace it with the column that your patching. You can't have a variable. For example, if I'm patching an Employee List, the Patch would be,
Patch(Employee_DB, Defaults(Employee_DB), { Emp_ID: "1", Emp_Name:" John Doe", Emp_Title:"Director" } )

Was this reply helpful? Yes No