Using IF statement in a Patch for a Status choice column in Dataverse

(0) Share

Report

Posted on by Cgangweg01

870 Super User 2026 Season 1

Hello -

What I thought was straight forward apparently isn't!

Appreciate the help in advance.

What is the syntax for the conditional patch in this scenario?

I want to patch the Status choice column in Dataverse table to value 'In Review' if the Correction Type combo box selected value is 'Missing Punch', otherwise, the Status is 'Submitted'.

          //'Status (cr10e_status)':If(CorrectionType.Selected.Value = "Missing Punch", "In Review", "Submitted")
  
Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @Cgangweg01,

it should be

'Status (cr10e_status)':If(CorrectionType.Selected.Value = "Missing Punch", 'Status (cr10e_status)'.'In Review', 'Status (cr10e_status)'.Submitted)

if this fails try with,

'Status (cr10e_status)':If(CorrectionType.Selected.Value = "Missing Punch", 'Status (PayrollCorrectionRequests)'.'In Review', 'Status (PayrollCorrectionRequests)'.Submitted)

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,690 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @Cgangweg01,

The field won’t accept "In Review" or "Submitted" as text, and it also won’t accept a {Value:"In Review"} record for choice columns.

It expects the actual Option Set value, which must be referenced like this:

'Status (cr10e_status)'.'In Review'

Try this code in Patch for update the status conditionally:

'Status (cr10e_status)': If( CorrectionType.Selected.Value = "Missing Punch", 'Status (cr10e_status)'.'In Review', 'Status (cr10e_status)'.Submitted )

📩 Need more help? Mention @DeveloperAK anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

1 people found this reply helpful.

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @Power Platform 1919 and @DeveloperAK -

Thank you for the replies.

This has gotten me the closest, pictured. But I'm getting the following error now. I pasted the line below.

Any suggestions now?

'Status (cr10e_status)':If(CorrectionType.Selected.Value = "Missing Punch", 'Status (PayrollCorrectionRequests)'.'In Review','Status (PayrollCorrectionRequests)'.Submitted)

It boggles my mind why there are no single quotes around submitted at the end of this when there are single quotes around the status prior.

Thanks again!

Was this reply helpful? Yes No
Verified answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @Cgangweg01,

Can you try this

'Status (cr10e_status)': If(Text(CorrectionType.Selected.Value)="Missing Punch", 'Status (PayrollCorrectionRequests)'.'In Review', 'Status (PayrollCorrectionRequests)'.Submitted)

Or

'Status (cr10e_status)':If(CorrectionType.Selected.Value='Status (PayrollCorrectionRequests)'.'Missing Punch','Status (PayrollCorrectionRequests)'.'In Review','Status (PayrollCorrectionRequests)'.Submitted)

Was this reply helpful? Yes No
Verified answer

Power Platform 1919 2,205 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

And for the single quote, we generally add quotes for choices with multiple words (example :In Review).

And we didn't add any quotes for submitted is because it is single word.

This is my thumb rule for remembering this can be wrong also as some choices have special characters too. In that case we have to add quotes.

Was this reply helpful? Yes No
Cgangweg01 870 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @Power Platform 1919

Thank you for the explanations! Really appreciate that.

Got it to work with this as your replied as I was interpreting the error.

'Status (cr10e_status)':If(CorrectionType.Selected.Value = 'CorrectionType (PayrollCorrectionRequests)'.'Missing Punch', 'Status (PayrollCorrectionRequests)'.'In Review','Status (PayrollCorrectionRequests)'.Submitted)

Was this reply helpful? Yes No