Hi Community,
I'm working on an internal project for Task trackers where I have created a power app and one of the screens wants to display the data in a column chart. after searching on the web and community was not able to find any help.
I have a SharePoint list as Datasource from which I have created a collection for only 3 fields of the entire list out of which 2 are choice columns (field_3 and filed_10) namely and Date of MI closure as field_1 with the following code
ClearCollect(
CollListColumns,
ShowColumns(
'PMIT TRACKER OMC AUT',
"field_1", // Make sure this column exists and has values
"field_3", // Extract the text value from the choice column with spaces
"field_10" // Extract the text value from the choice column
)
)
the Collection CollListColumns is set to items property of the table as below
now with this collection CollListColumns, I am trying to create column charts that dynamically load data based on the date pickers selected date
Items property of Table is set to
Filter(CollListColumns,field_1>=DatePicker1.SelectedDate&&field_1<=DatePicker2.SelectedDate) which loads the data in the table based on the selected date.
now here is what I'm not able to achieve when trying to create a code for my items property of the column chart
with the following code
AddColumns(
GroupBy(
Filter(
'CollListColumns',
field_1 >= DatePicker1.SelectedDate && field_1 <= DatePicker2.SelectedDate
),
"field_3",
"Group"
),
"Count",
CountRows(Group)
) This is throwing an error stating that field_3 doesn't exist tried replacing it with original names from the SharePoint name, table name, and all possible ways didn't help please help here to achieve in represent the data or any other ways to show the choice count in chart based on date range.
Thanks in advance 
