Syntax Errors in PowerApps Collection Creation Formula

Question

I am writing to report an error I encountered in the exercise module titled "Create formulas to change behaviors in a Power Apps canvas app". The module is designed to guide users through a step-by-step process to perform a specific task in PowerApps.

Issue Description: The module instructs users to input a formula to create a collection within PowerApps. However, the provided formula contains syntax errors that prevent the collection from being created successfully.

Erroneous Formula Provided: The original formula provided in the module is as follows:

ClearCollect(TestScoresCollection,{Name:"Student 1," TestScore:"B"},{Name:"Student 2," TestScore:"C"},{Name:"Student 3,"TestScore:"A"},{Name:"Student 4," TestScore:"C"},{Name:"Student 5," TestScore:"A"})

Errors Identified:

• Incorrect usage of quotation marks.
• Missing commas between the records.
• Potential unrecognized variable TestScore.

Corrected Formula: The correct formula, which functions as intended, is:

ClearCollect(TestScoresCollection, {Name: "Student 1", TestScore: "B"}, {Name: "Student 2", TestScore: "C"}, {Name: "Student 3", TestScore: "A"}, {Name: "Student 4", TestScore: "C"}, {Name: "Student 5", TestScore: "A"})

Suggested Action: I kindly request that the module be updated with the corrected formula to ensure a smooth learning experience for all users. The correct formula will allow users to create the collection without any syntax issues.

Thank you for your attention to this matter.

Answer 1

Hi Claudio Galiano,

Thank you for your patience.

We have reached out to the content author and got a confirmation saying that they had fixed the issue.

Please Accept the Answer so that it will be useful for others in the community.