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

Filter on Collection

hello everyone,

Can I create a collection from a datasource filtering by current userId. I Just want to collect data from the current user. I want to limit, so i can make my app faster and won't have that problem that only 2000 items can be shown.

Any help

 

Thanks,

Everyone

2 ACCEPTED SOLUTIONS

Accepted Solutions

SharePoint....I want to create a collection of data by current user: like

ClearCollect(TableSource,UserID=CurrentUserID,CollectTable)

Something like. Is that posible? I know you can filter by using a Gallery but I want a collection.

Thanks

View solution in original post

Thank you very much....

View solution in original post

5 REPLIES 5
Drrickryp
Super User
Super User

Hi @LEARN_IT,

What type of Datasource are you using? ie. Excel, Sharepoint, Sql server, etc.

Sharepoint....

SharePoint....I want to create a collection of data by current user: like

ClearCollect(TableSource,UserID=CurrentUserID,CollectTable)

Something like. Is that posible? I know you can filter by using a Gallery but I want a collection.

Thanks

View solution in original post

Hi @LEARN_IT,

No problem at all.  In the OnStart property of your first screen type Set(username,User().FullName);;Collect(coldatasource,Filter(Datasource,Author.DisplayName=username))

You should be able to use coldatasource in your formulas 

Thank you very much....

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,480)