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
User | Count |
---|---|
171 | |
90 | |
74 | |
69 | |
58 |
User | Count |
---|---|
213 | |
159 | |
98 | |
90 | |
73 |