Hi Community,
getting crazy with this stupid date time format expression filter.
In test environment we have a german sitecollection / library / date coulmn
There the filter which workfs fine with:
The coulmn show the date eg 30.6.2020
Next_x0020_Review_x0020_Due_x0020_By eq 'formatDateTime(addDays(utcnow(),-7),'yyyy-MM-dd')'
In Prod there is a english sitecollection and the same filter doesn't work
The coulmn show the date eg 2020/06/30
How is the correct expression for the english library / column ?
Best regards
Solved! Go to Solution.
Hi @MD2409_ ,
Please try to run Get items action without configuring Filter Query first and check the Body of the action.
Get the display name of the specified date column and check the format of the date.
Then you could configure Filter Query again and format the date parameter to filter items.
Best Regards,
HI @MD2409_
Have you tried following expression in prod:
Next_x0020_Review_x0020_Due_x0020_By eq 'formatDateTime(addDays(utcnow(),-7),'yyyy/MM/dd')'
Regards,
hi @MD2409_ you can try @DeepakS sols the format is 7/13/2017 or you can change the column format.
https://sharepointmaven.com/change-date-format-sharepoint/
Proud to be a Flownaut!
Hi @MD2409_ ,
Please try to run Get items action without configuring Filter Query first and check the Body of the action.
Get the display name of the specified date column and check the format of the date.
Then you could configure Filter Query again and format the date parameter to filter items.
Best Regards,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
57 | |
40 | |
39 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
52 | |
42 |