Unanswered

Patch Error: The type of this argument does not match the expected type 'OptionSetValue' - Found Type - 'Record'

(0) Share

Report

Posted on by MonaliB

I am using Patch function to update status column of type choice in dataverse table using the below function and I am getting an error - "The type of this argument does not match the expected type 'OptionSetValue' - Found Type - 'Record'"

Dataverse Table Name - Trainings

Column Name - Training_Status

The function used is as below:

Patch('Trainings', LookUp(Trainings, Training = ThisRecord.Trainings), {Training_Status : {Value: "Approved"}})

Any Suggestion?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (1)

All responses (4)

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
hi @MonaliB ,
try this:
Patch('Trainings', LookUp(Trainings, Training = ThisRecord.Trainings), {Training_Status : {Value: "Approved"}})

Was this reply helpful? Yes No
MonaliB 17 on at

Like (0)

Report

Still same error. It was a typo. I have corrected the bracket.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Patch('Trainings', LookUp(Trainings, Training = ThisRecord.Trainings, {Training_Status : LookUp(datasourceName,'column Name'.Value="Approved")}))
try this just replace the datasource name and column name

Was this reply helpful? Yes No
MonaliB 17 on at

Like (0)

Report

Thank you for your response Anand. Still giving an error. The Status column does not have Value property. The error is "Value isn't recognized."

Was this reply helpful? Yes No