Answered

Switching Views

(0) Share

Report

Posted on by IBrant

I have a working formula for switching to one alternate view but when I try to add another view, it didn't work. I'm not sure if my formula for the second view is correct but I'm trying to filter for only those actions that are not complete. Any assistance is appreciated!

Working formula:

SortByColumns(

Switch(

Dropdown1_1.Selected.ViewName,

"My Candidates",

Filter([@'Recruitment tracker'],Recruiter.Email = User().Email),

Filter([@'Recruitment tracker'],StartsWith('Candidate Name', TextSearchBox1_1.Text))

"Title",

If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)

)

Attempted to add View:

SortByColumns(

Switch(Dropdown1_1.Selected.ViewName, "My Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email), "My Active Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email && 'Action Complete' = "No", Filter([@'Recruitment tracker'], StartsWith('Candidate Name', TextSearchBox1_1.Text))), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @IBrant ,

This looks fine to me. I am assuming you're data source is SharePoint and "Action Complete" is a Yes/No field type? If yes, replace 'Action Complete' = "No" with 'Action Complete' = false

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report
Copy link

Link copied!

It is currently a dropdown choice yes/no in my SharePoint list. I originally had it as a yes/no but it populated as a toggle in the app so I changed it. I tried your formula, but it still didn't work for me. Thanks for your assistance!

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@IBrant - for a SharePoint Choices column, you will need: 'Action Complete'.Value = "No".

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report
Copy link

Link copied!

Hi, Amik,

I tried the above and it still didn't work. I also tried adding a "complete" column with a toggle and the previous solution and that did not work either. These are the formulas that I tried:

SortByColumns(
Switch(Dropdown1_1.Selected.ViewName, "My Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email), "My Active Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email && 'Action Complete'.Value = "No", Filter([@'Recruitment tracker'], StartsWith('Candidate Name', TextSearchBox1_1.Text))), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

SortByColumns(
Switch(Dropdown1_1.Selected.ViewName, "My Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email), "My Active Candidates", Filter([@'Recruitment tracker'],Recruiter.Email = User().Email && Complete = false, Filter([@'Recruitment tracker'], StartsWith('Candidate Name', TextSearchBox1_1.Text))), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
IBrant on at

Like (0)

Report
Copy link

Link copied!

Working:
Not Working:

Was this reply helpful? Yes No
IBrant on at

Like (1)

Report
Copy link

Link copied!

Hi Amik,
I tried it again and it worked. I don't know why it wasn't working before, but thank you so much for your help!

Was this reply helpful? Yes No