Filter on Collection

[LEARN_IT]

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

[Drrickryp]

Hi @LEARN_IT,

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

[LEARN_IT]

Sharepoint....

[LEARN_IT · Accepted solution]

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

[Drrickryp]

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 

[LEARN_IT · Accepted solution]

Thank you very much....