web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tP9xxeQBf/Lak4I3IHlfuF
Power Apps - Building Power Apps
Unanswered

LineChart ClearCollect syntax error

Like (1) ShareShare
ReportReport
Posted on 21 Aug 2024 16:36:23 by 2
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)
    )
);
 
Immediately I got multiple errors:
 
 
Your assistance is highly appreciated
 
 
 
  • WarrenBelz Profile Picture
    148,894 Most Valuable Professional on 21 Aug 2024 at 22:30:24
    LineChart ClearCollect syntax error
    This seems to be the same question as this thread

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete