Комментарии:
This doesn't work for me. The only way I can get any results to be returned is by using the format 'dd-MM-yyyy' - but the data returned then is incorrect. I am looking at documents in a document library from 3 days ago, using Created ge 'formatDateTime(addDays(utcNow,-3),'yyyy-MM-dd')' and getting no results, when there should be 43 results returned. What could I be doing wrong? 'MM-dd-yyyy' returns no results either
Ответитьi want to filter the week but all i have is date
ОтветитьHi, I want to filter a calculated column from a Sharepoint online list. This calculated column is formatted with the format date (DD.MM.YYYY). I have watched dozens of videos but no one shows this. Actually it is about a classic document management with a column date as format date, a column 365 days as format number and just this calculated column review date (column date + days = review date) as format date. In my power automate flow I would like to know which records are older than 365 days based on the current date.
ОтветитьMy data source is sharepoint online list. The datetime column format is dd/MM/yyyy. How could I write the query in correct format? I tried to apply formatDateTime(StartTime) but the expression is syntax error. (Starttime is my sharepoint list column)
ОтветитьWhat would be the expression if I want to get items that are older than 3 months from the day the flow runs. So each time I run the flow, it'll get the items with a date over 3 months in the past? Thanks!
ОтветитьHi, I want to get the latest date and time when a new form is submitted on MS forms and populated to Sharepoint list. I am doing an approval process, so if I have an existing entry in the sharepoint list, the formula you have given will take 2 of the list which I do not want. I just need to get the latest date and time. Do you know how I can do it and what formula do I need to insert? Thank you for your help.
ОтветитьCan we do this in Excel? I want to filter record which is submitted post 9AM only. Please help
ОтветитьThank you 😊 )))))) is it possible I can send an email to due date of customer in same sheet and remain will be according to date set.
Ответить