Error in Power Apps formula

(1) Share

Report

Posted on by MG-02091924-0

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.

Categories:

Experimental features

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

ohartzer 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No