All,
I am trying to run a Get Items action using a Filter query to obtain results between my StartDate and EndDate for 7 days out as such:
StartDate ge (utcnow()+7),'dd-MM-yyyy') and Enddate lt (utcnow()),'dd-MM-yyyy'))
this is giving me the following error:
{"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"The expression \"StartDate ge (utcnow()+7),'dd-MM-yyyy') and Enddate lt (utcnow()),'dd-MM-yyyy'))\" is not valid."}}}
so not being a Filter Query guru - what is the correct syntax for obtaining what I am trying to do.
Solved! Go to Solution.
Hi @koneill2020 ,
Please try:
StartDate gt '@{addDays(utcNow(),7,'yyyy-MM-ddTHH:mm:ssZ')}' and Enddate lt '@{utcNow('yyyy-MM-ddTHH:mm:ssZ')}'
Best Regards,
Bof
Hi @koneill2020 ,
try using addDays(utcNow(),7) instead of your brackets.
Hi @koneill2020 ,
Please try:
StartDate gt '@{addDays(utcNow(),7,'yyyy-MM-ddTHH:mm:ssZ')}' and Enddate lt '@{utcNow('yyyy-MM-ddTHH:mm:ssZ')}'
Best Regards,
Bof
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
32 | |
28 | |
27 | |
21 | |
10 |