I have a checkbox in which I want the default value to be pulled from a SharePoint List item. I have a Gallery set up and upon selection of the item, I set the following variable: Set(varRecord, ThisItem). I have several fields (not in a form) that I want to populate with the SharePoint column values associated with this record. One of the columns is populated with "Yes"/"No", and I want a checkbox to either show as true (checked) if the Item value is "Yes" and the opposite for "No."
I have the Default property set as follows:
If(varRecord."column_name" = "Yes", true, false)
But this is not working. It seems to be "remembering" the last values from a previous selection and ignoring this expression. I have confirmed that varRecord."column_name" is pulling the correct value, but the checkbox is not displaying it.
Any help would be greatly appreciated!
Thanks!
Renee
Solved! Go to Solution.
Try this: If there are no spaces in your column name it shouldn't need "" around it.
Switch(
varRecord.column_name,
"Yes",
true,
"No",
false
)
What type of column is the Yes/No column in the SharePoint list?
It’s a text field.
Try this: If there are no spaces in your column name it shouldn't need "" around it.
Switch(
varRecord.column_name,
"Yes",
true,
"No",
false
)
User | Count |
---|---|
261 | |
110 | |
89 | |
53 | |
44 |