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

Collection question

Hi everyone. I have a SP list that has 20 columns and 1500 rows.  One of the columns is LOCATION.  I am trying to pull in all rows where the location is equal to the location of the user, which is a variable called "varuser.department".  I can pull in all the data by using ClearCollect(colStoreDefects,TTDDefectsAll) I just dont know the syntax to filter out the other departments.  The varuser.department will return a 4 digit number as the department.

 

Thanks everyone!

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@ckserra 

Please consider changing your Formula to the following:

ClearCollect(colStoreDefects, Filter(TTDDefectsAll, LOCATION = varuser.department))

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

2 REPLIES 2
RandyHayes
Super User
Super User

@ckserra 

Please consider changing your Formula to the following:

ClearCollect(colStoreDefects, Filter(TTDDefectsAll, LOCATION = varuser.department))

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes 

 

That worked perfectly, thank you very  much!

 

Chris

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (4,609)