cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
resteve
Helper I
Helper I

filter gallery by date

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".

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
JRaasumaa
Memorable Member
Memorable Member

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

Sharepoint list

v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Powerplatform01
Post Patron
Post Patron

@resteve 

Hi you can watch this video

https://youtu.be/jw_E5hFBk28

Also request you to please subscribe this PowerAutomate channel

 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (3,990)