cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Set Variable not working after doing a clearcollect on visible

I am unsure how to explain this. I have 3 filter dropdowns filtering on a gallery. When the app starts I want the dropdowns to default to "ALL". I am populating the dropdowns with collections: 

 

The onvisible for the main screen is:

ClearCollect(
   colProjects,
   AddColumns('Project and Status',"ProjectTypeText",Project_x0020_Type.Value,
   "ProjectMgrText", Project_x0020_Manager.DisplayName));
ClearCollect(
   colProjectType,
   Distinct(colProjects,ProjectTypeText));
   Collect(colProjectType,{Result:"All"});
ClearCollect(
   colProjectMgr,
   Distinct(colProjects,ProjectMgrText));
   Collect(colProjectMgr,{Result:"All"});
ClearCollect(
   colCustomer,
   Distinct(colProjects,Customer_x0020_ID));
   Collect(colCustomer,{Result:"All"});
ClearCollect(
   colFilterProjects,colProjects);
Set(varAll,"All")

 

I have the Onchange of each dropdown:

ClearCollect(
   colFilterProjects,
   Filter(colProjects,
   Customer_x0020_ID = drpCustomer.Selected.Result ||drpCustomer.Selected.Result = "All",
   ProjectMgrText = drpProjectMgr.Selected.Result ||drpProjectMgr.Selected.Result = "All",
   ProjectTypeText = DrpProjectType.Selected.Result ||DrpProjectType.Selected.Result = "All"
))

I also have the "default" = varAll and the "Items" = 

Customer = Sort(colCustomer,Result) 

Project Type = Sort(colProjectType,Result)

Project Lead = Sort(colProjectMgr,Result)

 

When i start the App, the default is never "All" and when i navigate back to the main page after setting them all to "All" it always defaults to the first selection not "All"

 

I have tried using the same script used on the on visible, in the on start. I have tried just putting the Set(varAll,"All") on navigations from other screens to the main. I am not coming up with anymore ideas. Have been trying all sorts of things. 

Any help would be appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper III
Helper III

Re: Set Variable not working after doing a clearcollect on visible

I was able to keep the dropdowns and everything I had on the onvisible. I just added reset(drpcustomer);reset(drpprojecttype);reset(projectMgr)

View solution in original post

3 REPLIES 3
Highlighted

Re: Set Variable not working after doing a clearcollect on visible

Ok, I've built a test app with this:

 

OnVisible:

ClearCollect(types, Choices('Powered List'.Receipt_x0020_type));
Collect(types, "All")

I had a ComboBox so:

Items:

types

DefaultSelectedItems:

Last(types)

Since the "All" item was the last one on the list, it gets selected from the collection.

 

I hope this works.

Highlighted
Resident Rockstar
Resident Rockstar

Re: Set Variable not working after doing a clearcollect on visible

Hi Rebeccak,

 

First, next time place your code in a codeblock, this makes it easier to read.

 

Next, get rid off the DropDownbox and replaces them bij ComboBoxes. Disable the multiselect and optional the search parameter.

 

Then do this OnVisible:

ClearCollect(colProjects, AddColumns('Project and Status',"ProjectTypeText",Project_x0020_Type.Value,"ProjectMgrText", Project_x0020_Manager.DisplayName));
ClearCollect(colProjectType,Distinct(colProjects,ProjectTypeText));
ClearCollect(colProjectMgr,Distinct(colProjects,ProjectMgrText));
ClearCollect(colCustomer,Distinct(colProjects,Customer_x0020_ID));
ClearCollect(colFilterProjects,colProjects);
Set(varAll,"All")

Default the Combobox will be empty and you can use the Searchtext to tell please what to do (On this moment when search is enabled, but I post the idea for a hinttext on this control.)

 

Then on the controls do like this:

ClearCollect(colFilterProjects,
Filter(colProjects,
(IsBlank(drpCustomer.Selected.Result) || Customer_x0020_ID = drpCustomer.Selected.Result),
(IsBlank(drpProjectMgr.Selected.Result) || ProjectMgrText = drpProjectMgr.Selected.Result)
// (IsBlank(DrpProjectType.Selected.Result) || ProjectTypeText = DrpProjectType.Selected.Result)
//Don't put in a line for the combobox itself
)
)

You must remove the line which states the combobox itselfs (so with 3 controls you get 2 lines). The IsBlank() will be true when the combobox is empty, so basically when both comboboxes are empty the first condition in a line will be true. 

 

Maybe you should add a reset() formula also to reset specific boxes on selection, mostly this you will do from the first combo (for the second and third) and the second combo (for the third). 

 

Use the same IsBlank() formula for filtering your gallery (if you use one) and it should work.

 

Hope this helps.

 

Paul

Highlighted
Helper III
Helper III

Re: Set Variable not working after doing a clearcollect on visible

I was able to keep the dropdowns and everything I had on the onvisible. I just added reset(drpcustomer);reset(drpprojecttype);reset(projectMgr)

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,980)