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

[eka24]

Try:

Patch([@Alerts], ThisItem, {Level : LookUp(Level, qrs_alertstate="Okay")})

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dr_David_Banner]

the message I get is "function lookup as some invalid arguements" 

the name isn't valid, this identifier isn't recognised" 

Thanks

" 

[eka24]

Please give a screenshot

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Dr_David_Banner]

[Dr_David_Banner]

I think the problem, for whatever reason is it can't find qrs_alertstate ? 

[v-siky-msft]

Hi @Dr_David_Banner ,

Could you please try this? The option set also need to marked by a disambiguation operator

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

Hope this helps.
Sik

[Dr_David_Banner]

thanks for your suggestion, this is what I get:

[v-siky-msft]

Hi @Dr_David_Banner ,

OK, What is the Option Set Name (Not the Option Set Field Name)?

Could you please share the Option Set Field property shown as below?

Sik

[Dr_David_Banner]

sure: 

thanks