cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Usernametwice23
Helper V
Helper V

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

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

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
)

 

View solution in original post

3 REPLIES 3
gabibalaban
Super User
Super User

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

Screenshot 2021-09-18 161809.png

Hi @gabibalaban Thanks for your help.

I get this error seen in the screen shot after trying this.

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
)

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,622)