Easy Syntax question

(0) Share

Report

Posted on by slhangen

356

Getting an error with following syntax but can't figure out where my error is. Any help would be much appreciated.

SortByColumns

(If

(ddLevelSelector.SelectedText.Value= "All Levels", Interventions,
Filter(Interventions, ddLevelSelector.SelectedText.Value=ConcernLevel,
"ReferralDate", Descending, "LastName", Ascending, "LastName", Ascending
)
)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@slhangen

Please consider changing your Formula to the following:

SortByColumns Filter(Interventions, (ddLevelSelector.SelectedText.Value= "All Levels" || ddLevelSelector.SelectedText.Value=ConcernLevel) ), "ReferralDate", Descending, "LastName", Ascending, "LastName", Ascending )

Also, you should replace the SelectedText properties in your formula as it is a deprecated property.

I hope this is helpful for you.
Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @slhangen ,
Do you want to display “Interventions” when ddLevelSelector.SelectedText.Value= "All Levels" , otherwise display the results of Filter(Interventions, ddLevelSelector.SelectedText.Value=ConcernLevel) ?
If yes, maybe you place the “)” in a wrong location.
Also, if ConcernLevel is one of the choices from ddLevelSelector, you should use ddLevelSelector.SelectedText.Value=”ConcernLevel” in Filter() as a condition.
You can try below formula:
SortByColumns (If (ddLevelSelector.SelectedText.Value= "All Levels", Interventions, Filter(Interventions, ddLevelSelector.SelectedText.Value=”ConcernLevel”)) "ReferralDate", Descending, "LastName", Ascending, "LastName", Ascending )
Best Regards,
Allen
slhangen 356 on at

Like
a
(0)

Report
Copy link

Link copied!

Works perfectly! Been fighting this for weeks.

Thanks again!!!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@slhangen

In general, it is not good practice to put If statements to select two (or more) datasources. In your case you are taking the suggestion of @v-albai-msft which uses this method.

Take a look at the formula I provided as it avoids this bad practice.

And..for your weeks of fighting...hit up the forums as soon as you start to struggle. Plenty of minds here that will get you on the right course and save you some time. 😁