cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rebeccak
Level: Powered On

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
Rebeccak
Level: Powered On

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
Eickhel
Level 8

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.

KroonOfficeSol
Level 10

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

Rebeccak
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,732)