Unanswered

Building Power App_Request help to load data from choice columns. Incompatile Tables vs Text

(1) Share

Report

Posted on by deepaksharma_0

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,721 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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 ??

Was this reply helpful? Yes No
deepaksharma_0 16 on at

Like (1)

Report
Copy link

Link copied!

Ok. Code is below. Choice column 'Tire Condition' accepts single value. But few fields accept multiple values
ClearCollect(
ColInspectionData,
'DailyForklift/OrderPickerInspectionReport'
);

ClearCollect(
ColOkCounts,
{
TireCondition: CountIf(ColInspectionData, TireCondition.Value = "Ok"),
HeadLights: CountIf(ColInspectionData, HeadLights.Value = "Ok"),
WarmingLights: CountIf(ColInspectionData, 'Warming Lights'.Value = "Ok"),
HourMeter: CountIf(ColInspectionData, 'Hour Meter'.Value = "Ok"),
Horn: CountIf(ColInspectionData, Horn.Value = "Ok"),
AnyLeaks: CountIf(ColInspectionData, 'Any Leaks'.Value = "Ok"),
Steering: CountIf(ColInspectionData, Steering.Value = "Ok"),
ServiceBrake: CountIf(ColInspectionData, 'Service Brake'.Value = "Ok"),
ParkingBrake: CountIf(ColInspectionData, 'Parking Brake'.Value = "Ok"),
MastCondition: CountIf(ColInspectionData, 'Mast Condition'.Value = "Ok")

}
);

Was this reply helpful? Yes No
WarrenBelz 153,721 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@deepaksharma_0 ,

The issue will be with the multi-value fields - example using HourMeter

HourMeter: CountIf(ColInspectionData, "Ok" in 'Hour Meter'.Value),

Was this reply helpful? Yes No