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:

Using Apps Using Formulas

All responses (6)

Answers (1)

IBrant on at

Like (1)

Report

Re: Switching Views

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!
IBrant on at

Like (0)

Report

Re: Switching Views

Working:
Not Working:
IBrant on at

Like (0)

Report

Re: Switching Views

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))
Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report

Re: Switching Views

@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.
IBrant on at

Like (0)

Report

Re: Switching Views

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!
Verified answer

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

Like (0)

Report

Re: Switching Views

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.