As you see in sharepoint list, i have columns say ' Tire Condition'. It is a choice column and values are Ok or Not Ok. I want to show count of Ok and count of not ok in a gallery. I created a collection in 'On Start' to get Ok values but it keeps giving error. Answer should have been 3 for Ok count.
List
Code in On Start of App- showing collection has all inspection data from above sharepoint list
Code in On Start of App which has Errors. I tried with and without .Value but error does not go away on signs
The issue will be with the multi-value fields - example using HourMeter
HourMeter: CountIf(ColInspectionData, "Ok" in 'Hour Meter'.Value),
Ok. Code is below. Choice column 'Tire Condition' accepts single value. But few fields accept multiple values
Hi @deepaksharma_0 ,
Can you please remember to post your code in Text as it saves re-typing here. The first error is because you have single quotes ' around ok instead of double quotes " on the first line.
Apart from that, what type of fields are all those patched to for the Choice examples, are they single or multiple value ??