Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Power Platform Community / Forums / Power Apps Experimental Features / Error in Power Apps fo...
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
    FLMike Profile Picture
    FLMike 23,258 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.
     
     

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 140,719

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,355

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans