Unexpected characters. Characters are used in the formula in an unexpected way error?

(0) Share

Report

Posted on by Usernametwice

503

Hi everyone

I am so close to figuring this out, the syntax is just giving me an error when i try to filter down on the (views) table. I am getting the error mentioned in the heading.

Here is the syntax I receive the error on -

SortByColumns(Filter('Daily Measurement', Person.Name=Gallery.Selected.Person.Name),"dlg_number",Ascending), 'Daily Measurement (Views)'.'Today Active')

I think it's the last part of the formula but I need to filter it based on these parameters because that's where the records I need are at. Any Idea how I can include 'Daily Measurement (Views)'.'Today Active')' without the error?

Thanks and Kind regards everyone.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
SortByColumns( Filter('Daily Measurement', Person.Name=Gallery.Selected.Person.Name), "dlg_number", Ascending).'Daily Measurement (Views)'.'Today Active'

Was this reply helpful? Yes No
Usernametwice 503 on at

Like (0)

Report

Hi @gabibalaban Thanks for your help.
I get this error seen in the screen shot after trying this.

Was this reply helpful? Yes No
Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Usernametwice23

If you want to apply an additional filter condition to your 'Today Active' view, I would try the following syntax:

SortByColumns( Filter('Daily Measurement', 'Daily Measurement (Views)'.'Today Active', Person.Name=Gallery.Selected.Person.Name ), "dlg_number", Ascending )

Was this reply helpful? Yes No