unable to patch choice column in SP list

(0) Share

Report

Posted on by shoebwk

118

Hi,

Trying to patch the existing SP list record choice column with the attached command but unable to get the result

After execution the gethelp on error shows "The specific record was not found" though SP list has the record with status"Reported".

Appreciate a quick help

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Pstork1 69,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Try the following code instead

ForAll( Filter( GalleryReported.AllItems, Status.Value = "Reported" ), Patch( Mobility, ThisRecord, {Status: {Value: "Approved"}} ) )

Since Status is a Choice column you have to patch it with an object record. {Value:"Approved"} will set the value property of the Status record.

Was this reply helpful? Yes No
shoebwk 118 on at

Like (0)

Report
Copy link

Link copied!

Getting the same error {attached}
I can also see the Internal Field name for Status column is
/_layouts/15/FldEdit.aspx?List=%7B6BF7CC6C-A494-4A9C-A242-983541A87B83%7D&Field=pcof

Was this reply helpful? Yes No
Pstork1 69,427 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Change it to use the internal field name. I tested it on a choice column in one of my lists where the internal name is 'status' and it works for me.

Was this reply helpful? Yes No
shoebwk 118 on at

Like (0)

Report
Copy link

Link copied!

I am not sure why it is not work.
Here I removed the complex column dependencies and now both the columns in powerapps in SP list are text field. Still I am getting the same error

ForAll(
Filter(
GalleryReported.AllItems,
ApprovalStatus = "Reported"
),
Patch(
Mobility,
ThisRecord,
{ApprovalStatus:"Approved"}
)
)

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @shoebwk ,

Could you tell me:

1)status field data type?

2)what does "ThisRecord" represent? a variable ? or something else?

If you want to update all the items that ApprovalStatus = "Reported" to ApprovalStatus:"Approved", you should use formula like this:

ForAll( RenameColumns( Filter( GalleryReported.AllItems, ApprovalStatus = "Reported" ), "ID","ID1"), Patch( Mobility, ID=ID1, {ApprovalStatus:"Approved"} ) )

If Status is single choice column, try this formula:

ForAll( RenameColumns( Filter( GalleryReported.AllItems, Status.Value = "Reported" ), "ID","ID1"), Patch( Mobility, ID=ID1, {Status: {Value: "Approved"}} ) )

Best regards,

Was this reply helpful? Yes No