Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Apps Experimental Features / Error in Power Apps fo...
Power Apps - Power Apps Experimental Features
Suggested answer

Error in Power Apps formula

(1) ShareShare
ReportReport
Posted on by MG-02091924-0 4
Hi, I've been having trouble with this Power Apps formula, I'm starting to learn how to create apps, and trying to create a questionnaire with SharePoint as well as following a tutorial. However, it seems to give a syntax error
This is the formula I'm using
 
 

ClearCollect(

    colQuestions,

    ShowColumns(

        AddColumns(

            Questions,

            "Answers",

            Table(

                {Answer: ThisRecord.Option1},

                {Answer: ThisRecord.Option2},

                {Answer: ThisRecord.Option3},

                {Answer: ThisRecord.Option4}

            )

        ),

        "Title",

        "Answers"

    )

)

I don't know what the error is. If anyone knows the solution or what I might be doing wrong, I would really appreciate it.
  • Suggested answer
    ohartzer Profile Picture
    ohartzer 4 on at
    Error in Power Apps formula
    Hi,

    just remove the " " from the column names.
     

    ClearCollect(

        colQuestions,

        ShowColumns(

            AddColumns(

                Questions,

                Answers,

                Table(

                    {Answer: ThisRecord.Option1},

                    {Answer: ThisRecord.Option2},

                    {Answer: ThisRecord.Option3},

                    {Answer: ThisRecord.Option4}

                )

            ),

            Title,

            Answers

        )

    )

    Happy low-coding
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 44,826 Super User 2025 Season 1 on at
    Error in Power Apps formula
    Hi,
     
    If you look at the Stethoscope in the top right, it should have a red dot like the one below. Click it and find the Screen that the error is on, and it will list all the errors. Before I just say what the issue is, I want you to find the error, and review it, bring it back here after you tried to resolve it and I'll help you resolve it.
     
     

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans