Skip to main content

Notifications

Community site session details

Community site session details

Session Id : bVWK0LAiTPmmtrp7oFvxUZ
Power Apps - Building Power Apps
Answered

expected boolean. we expect a boolean at this point in the formula.

Like (0) ShareShare
ReportReport
Posted on 25 Sep 2023 20:07:36 by 909 Super User 2024 Season 1

Hi,

 

SortByColumns(
 Filter(
 Filter(
 [@'data source'],
 Lower(User().Email) = Requestor_Email_two
 ),
 [@'data source'],'search box'.Text in ID_three
 ),
 "Title",
 If(
 SortDescending1,
 SortOrder.Descending,
 SortOrder.Ascending
 )
)

 

getting this error  on this line - [@'data source'],'search box'.Text in ID_three

wonka1234_0-1695672376194.png

expected boolean. we expect a boolean at this point in the formula.

 

using this documentation -

 

wonka1234_1-1695672441194.png

 

 

anyone know how I can fix this?

  • Verified answer
    SpongYe Profile Picture
    5,580 Super User 2025 Season 1 on 25 Sep 2023 at 20:13:21
    Re: expected boolean. we expect a boolean at this point in the formula.

    Hi @wonka1234 

     

    Please try this:

    SortByColumns(
     Filter(
     Filter(
     [@'data source'],
     Lower(User().Email) = Requestor_Email_two
     ),
     'search box'.Text in ID_three
     ),
     "Title",
     If(
     SortDescending1,
     SortOrder.Descending,
     SortOrder.Ascending
     )
    )

     

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 146 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 81

#3
stampcoin Profile Picture

stampcoin 68

Overall leaderboard
Loading started