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".
Solved! Go to 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:
Regards,
Michael
Where is your date data being stored? (sharepoint list, excel, collection, sql query)
Sharepoint list
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:
Regards,
Michael
Hi you can watch this video
Also request you to please subscribe this PowerAutomate channel
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
245 | |
122 | |
84 | |
83 | |
67 |