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

Can't create Collection using ClearCollect Function

I encountered a challenge when following the guidelines of this article.
In the Step: Writing the related schools into a collection

Faculty Field -> OnChange: 

ClearCollect( collSchools, { Schools: Filter( Schools, Faculty.Value = DataCardValue2.Selected.Value ) } )

Property Explanation

collSchoolsThis is our collection where all related schools for the selected faculty are written in to
SchoolsThis is the name of the column where the data is written in to
FilterThis is the function that filters values from a data set. The format of this function is as follows: Filter(source,logical_test)
SchoolsThis is the data set that we use in our filter. In this case, it is the Schools list we added as data source
Faculty.ValueThis is the value we are looking for in our data set. In this case, it is the Faculty lookup field in our Schools list
DataCardValue2.Selected.ValueThis is the selected faculty from our PowerApp

 

I follow this fomulas but the result is an empty collSchools Collection.

Here is my Form Setting

Screen Shot 2019-10-08 at 9.17.34 PM.png

And the OnChange of Faculty Dropdown:

Screen Shot 2019-10-08 at 9.18.52 PM.png

And the collSchools Collection: Empty School Column

Screen Shot 2019-10-08 at 9.19.26 PM.png

Can anyone help me resolve this problem?

11 REPLIES 11
Highlighted

@carem 

 

Ok so it means something is incorrect in your data

 

CountRows(Filter( Schools, Faculty.Value ="hardcoded value" ))

 

When you go to SP list Schools - does it have any data? I am assuming Yes

Does it have values in Faculty column - see the values there

then try and hardcode that value exactly in the hardcoded value in formula above and test

 

 

Highlighted

@RezaDorrani 

I have discovered a serious problem with Preview Mode. I think it is the cause of this problem.

My Preview Function is not working. It's mean when I press F5 you can see my form like this:

Screen Shot 2019-10-09 at 10.20.31 AM.pngEdit ModeScreen Shot 2019-10-09 at 10.20.24 AM.pngPreview Mode

It may be that it cannot recognize the value of drpd_Faculty.Selected.Value. And return an empty Collection.
Follow Pstork1's advice, I create a button with OnSelect Property:

ClearCollect( collSchools, { Schools: Filter( Schools, Faculty.Value = "Faculty of Health" ) } )

And it's work.

But when I go back for  

ClearCollect( collSchools, { Schools: Filter( Schools, Faculty.Value = drpd_Faculty.Selected.Value ) } )

It does not work anymore.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,640)