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

Like (0) Share

Report

Posted on 25 Sep 2023 20:07:36 by wonka1234

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

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

using this documentation -

anyone know how I can fix this?

All responses (1)

Answers (1)

Verified answer

SpongYe 5,580 Super User 2025 Season 1 on 25 Sep 2023 at 20:13:21

Like (1)

Report
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! 🍻