Power Platform Community Forum Thread Details

Greetings

I am trying to populate the PowerApps line chart with submissions from a SharePoint list and sort by month.

I have added the following Syntax to the properties of OnStart:

ClearCollect(CREQE_FormCollection, CREQE_Form);
ClearCollect(
CREQE_FormWithMonthYear,
AddColumns(
CREQE_FormCollection,
"MonthYear",
Text('Date of Request', "[$-en-US]yyyy-mm")
)
);
ClearCollect(
GroupedData,
AddColumns(
GroupBy(
CREQE_FormWithMonthYear,
"MonthYear",
"GroupedItems"
),
"MonthlyTotal",
Sum(GroupedItems, SubmissionAmount)
)
);