
Hi, Power Community,
For the life of me, I can't find how to refer to the value of a Yes/No option selection from Dataverse. In the below image, I'm trying to set the default boolean value to a toggle from a record from Dataverse:
SelectedRequest - record from Datavase
Referral Source - boolean column of the item
If nothing is selected from Dataverse, populate with the value from galVendors in the app. This is fine
Otherwise, populate it with the value in the Dataverse record, which is asking for the value of the OptionSetValue. I've tried different combos of .Selected, .Value, Value(), etc. to no avail. And searching thru the web suggests something may be done with using a JSON body, put it in a collection, and such but there has to be a sensible way of referring to the underlying value of a selected boolean option. Help, please!
Update...
Isolated the error and found that it only showed when both the values from the gallery control and the Dataverse record are used directly
If(IsBlank(SelectedRequest), galVendors.Selected.'Is Referral Source') fine
If(IsBlank(SelectedRequest), SelectedRequest.'Referral Source') also fine
It's when both are used that it throws an error arguing the value of the OptionSetValue in the Dataverse record be supplied
So worked around it and indirectly supplied the value from the gallery to the formula and no error
Don't understand why the conflict occurred when both record values are used, but hope this helps someone who comes upon the same problem