LineChart ClearCollect syntax error

(1) Share

Report

Posted on by NN-21081740-0

492

Greetings

I am trying to sort SharePoint Submissions by month and populate a LineChart in Power Apps.

This is my syntax and for some reason, it is giving me multiple errors.

I have it placed in the properties of Onstart as follows:

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)
)
);

Errors are saying invalid names and invalid, arguments; I am so confused right now. Please help me.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (1)

Report
Hi NN-21081740-0

You do not need quotes "" around the AddColumns or GroupBy parameters now.
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 ) ) );

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

NN-21081740-0 492 on at

Like (0)

Report

Thank you so much for removing the quotes around AddColumns and GroupBy parameters. To make it work 100% I needed to add quotes between SubmissionAmount like so: "SubmissionAmount"

Thanks a ton!!!

Was this reply helpful? Yes No