filter gallery by date

[resteve]

Hello,

I have this formula: "Total: " & Sum(BrowseGallery1.AllItems;Amount).

But now I would like to filter items only when field date is highter than first day of this month.

date>="01/07/2017".

[JRaasumaa]

Where is your date data being stored? (sharepoint list, excel, collection, sql query)

[resteve]

Sharepoint list

[v-micsh-msft · Accepted solution]

Hi @resteve,

Could you please explain a bit for where you woud like to put the filter, and what is this filter used for?

Besides, for the first day of this month, is it specially for "01/07/2017"?

If you would like to put the filter result within the items property of the BrowseGallery, then the suggested formula should be:

Filter('Testing list', Created>=Date(2017,7,1))

Things you need to know is currently < or > operator is not supported in delegation for SharePoint data source.

If they are used in the query formula, then you may notice the delegation notification, currenlty only "=" is supported delegation for SharePoint list.

For more details, please check:

Delegable data sources

Regards,

Michael

[Powerplatform01]

@resteve 

Hi you can watch this video

https://youtu.be/jw_E5hFBk28

Also request you to please subscribe this PowerAutomate channel