Need to add another condition to my sort by columns

(0) Share

Report

Posted on by burliad

183

Hi All,

I need to add another column to sort by in my app and not sure how to go about it. Code listed below

Need to Add column: Approved = Yes

If(varMode = "View All", SortByColumns(Filter([@'Master Chemical List'], StartsWith('Chemical Number', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)), SortByColumns(Filter([@'Master Chemical List'], PAC.Value = varMode, StartsWith('Chemical Number', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending)))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Try:
If(varMode = "View All", SortByColumns(Filter([@'Master Chemical List'], StartsWith('Chemical Number', TextSearchBox1.Text),Approved="Yes"), "Title", If(SortDescending1, Descending, Ascending)), SortByColumns(Filter([@'Master Chemical List'], PAC.Value = varMode, StartsWith('Chemical Number', TextSearchBox1.Text),Approved="Yes"), "Title", If(SortDescending1, Descending, Ascending)))

OR

If(varMode = "View All", SortByColumns(Filter([@'Master Chemical List'], StartsWith('Chemical Number', TextSearchBox1.Text),Approved=1), "Title", If(SortDescending1, Descending, Ascending)), SortByColumns(Filter([@'Master Chemical List'], PAC.Value = varMode, StartsWith('Chemical Number', TextSearchBox1.Text),Approved=1), "Title", If(SortDescending1, Descending, Ascending)))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
burliad 183 on at

Like
a
(0)

Report
Copy link

Link copied!

That did it, thank you so much! had to use the Approved =1

Was this reply helpful? Yes No
burliad 183 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm getting an incompatibility error with the code because its expecting text and not a number. Looks like everything still works, will this be a problem if I keep it that way or should I use a Text Function to convert it?

Was this reply helpful? Yes No
Verified answer

Jessie Chen on at

Like
a
(0)

Report
Copy link

Link copied!

@burliad this should not be a problem as it will still get results.

Best Regards,

Jessie Chen

Support Engineer

Asia Dynamics 365 Support

Customer Services and Support

Was this reply helpful? Yes No