You’re offline. This is a read only version of the page.
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
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
sure:
thanks
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
thanks for your suggestion, this is what I get:
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
I think the problem, for whatever reason is it can't find qrs_alertstate ?
the message I get is "function lookup as some invalid arguements"
the name isn't valid, this identifier isn't recognised"
Thanks
"
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (