Answered

Patch (update) using a collection with ShowColumns and Choice Fields

(0) Share

Report

Posted on by jms345

117

I have built a collection based on filters in a gallery, and want to only update 4 fields in the record. It successfully updates 2 of the fields but for some reason when I add 2 other fields I get an error on the button formula.

This part works:

Patch(
'School Application Form',
ShowColumns(colGridUpdate,
"ID",
"Status",
"MoveYear")
)

Status (Choices) and MoveYear (Yes/No) are fields in the Sharepoint list that are successfully updated.

When I try to add "Year of Entry" (Choices) and/or "StudentYearGroup" (Choices) the whole formula has red squiggly lines and it fails.

Can anyone shed light on this please?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @jms345 ,

The format you are using relies on the 'School Application Form' List having the fields you are showing in colGridUpdate with exactly the same name and field type, so that would be a good place to start looking (do they both have the Choice fields 'Year of Entry' and 'StudentYearGroup' ? )

Was this reply helpful? Yes No
Verified answer

jms345 117 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @WarrenBelz - I had double checked the field names but found a strange anomaly: when I changed "Year of Entry" to "Year_x0020_of_x0020_Entry" it accepted this fieldname in the Patch. However it wouldn't when I tried replacing the spaces in "Student Year Group". I went into the SP list and renamed the field to StudentYearGroup, and then put "StudentYearGroup" into the Patch statement. It now works.
I guess the rule should be create fieldnames without spaces...?

Was this reply helpful? Yes No
ChrisCham 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I try not putting spaces in any column name because you never know which function doesn't parse the space syntax correctly!

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jms345 ,

Yes - you will not find any spaces or special characters in any of my field names.

Was this reply helpful? Yes No