web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patch invalid argument...

Power Apps

Unanswered

Patch invalid arguments unexpected Schema and 'Status' is getting OptionSetValue and Using same?

(0) Share

Report

Report

Posted on by Daniel14

Happy Friday! I am very confused why this worked earlier in the week and now it is:

The function 'Patch' has some invalid arguments.
Invalid argument type. Expecting a Record value, but of a different schema.
Incompatible type. The 'Status' column in the data source you're updating expects a

'OptionSetValue' type and you're using a 'OptionSetValue' type.

The Patient Field (in the MedicalRelease table) I am patching into is a Lookup which has worked amazingly well, as I pull the information I need from the original table Patients table.

Questions:

1. Confused as to why NOW it has a different schema, no changes have been made between the Patients and the Release table

2. What is it really trying to tell me OptionSetValue?

Thanks for any help

Screen Shot 2022-02-25 at 9.51.52 AM.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Daniel14 ,

I suggest you create a support ticket for professional assistance following the below procedure.
Get Help + Support - Power Platform | Microsoft Docs

In addition, here are some links that might help you:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Status-expects-a-OptionSetValue-but-you-re-using-a/td-p/933002
https://powerusers.microsoft.com/t5/Building-Power-Apps/The-Access-Mode-column-in-the-data-source-you-re-updating/td-p/379619

Hope your problem can be solved as soon as possible.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Daniel14

Try below Query,

As per my example below Am passing lookup for Patient and Status as Optionset value

Patch(RequestToReleaseMedicalRecordss,ThisItem,{Patient:Lookup(PatientTable,PatientColumnFieldName = PatientColumnFieldValue)},{Status:Choices(Status).Active})

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No

Join the conversation