Unanswered

Syntax Error

(0) Share

Report

Posted on by np300

I am attempting to add columns "Title" and "Name" to a data table with info from my data source and am getting a syntax error

SortByColumns(
AddColumns(
GroupBy(
Filter(
Safetyl,
StartsWith(
Title,
Textlnput5.Text
)
),
"Title",
"All Titles"
),
"Discussions",
CountRows('All Titles'),
"Name",
First('All Titles').Name
),
"Title"
)

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@np300

I did a copy and paste of your formula into a different font. The letter I in your TextInput5 is showing as a lower case L, not an I.

Perhaps you need to look at that letter.

I hope this is helpful for you.
np300 8 on at

Like
a
(0)

Report
Copy link

Link copied!

That was an Issue. But same error appears
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@np300

The formula looks good for the most part, so if it is still showing that exact error, you might want to try re-typing in the formula to make sure it has the proper spelling/letters.

If still no joy, post back your corrected formula for review.
np300 8 on at

Like
a
(0)

Report
Copy link

Link copied!

SortByColumns(
   AddColumns(
      GroupBy(
         Filter(
            Safety1,
            StartsWith(
               Title,
               TextInput5.Text
            )
         ),
         "Title",
         "All Titles"
      ),
      "Discussions",
      CountRows('All Titles'),
      "Name",
      First('All Titles').Name
   ),
   "Title"
)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@np300

And the error you are now getting - is that exactly the same as before?
np300 8 on at

Like
a
(0)

Report
Copy link

Link copied!

AddColumns has invalid arguments
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@np300

Please explore your formula in the formula editor. At this point it should have red underlines on the formula. Look for the following...

- a thicker red underline in one area. Then hover over that for a more meaningful error.

- if no thicker underline is seen, then hover over functions in your formula, working from in to out (i.e. StartsWith, Filter, GroupBy would be in to out) and see what error the formula editor shows in the tool tip. That should lead you to which part of the formula (the area within the AddColumns function) that has the issue.