web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Choice Column

Power Apps

Answered

Patch Choice Column

(1) Share

Report

Report

Posted on by firda59

372

Hi,

I have SP list which column has choice column, I want to patch my data from PowerApps to SP List used this formula:
Patch(Data, Defaults(Data), {'Type of Defect': {Value: "No Defect"}}),

but I got error message:
The type of this argument 'TypeofDefect' does not match the expected type 'Table'. Found type 'Record'.

Can anyone fix my formula? Thankyou!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @firda59 ,
Ensure choice value "No Defect" exists in the SharePoint column's choices.
Patch(Data, Defaults(Data), {'Type of Defect': {Value: "No Defect"}})
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @firda59 ,

Please try this:
Patch(Data, Defaults(Data), {'Type of Defect': Table({Value: "No Defect"}),RequiredColumnName:"test"})

Best regards,
Rimmon

Join the conversation