Patch a CDS option set from canva app

[Dr_David_Banner]

Hi

I'm trying to patch a CDS option set from my Canvas app using a button. 

The CDS entity is called 'alerts' the field is called 'Level" and the option set is called 'qrs_alertstate'. Alertstate has a few values; Critical, Warning and OK. 

for the life of me I can't get this to update. Here is my code: 

Patch([@Alerts], ThisItem, {Level : 'Level'.Okay})

can anyone help? 

thanks in advance

[v-siky-msft · Accepted solution]

Hi @Dr_David_Banner ,

Yes, that is the problem.

The Option Set Name is Alert State, the code should be:

Patch([@Alerts], ThisItem, {Level : [@'Alert State'].'Okay'})

Hope this helps.

Sik

[Dr_David_Banner]

@v-siky-msft 

Amazing, thank you very much, that's really helped me out 🙂