cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dual Super User
Dual Super User

Re: Can't create Collection using ClearCollect Function

@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
Helper III
Helper III

Re: Can't create Collection using ClearCollect Function

@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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,987)