Answered

Issue with date from Sharepoint - about to lose my mind

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am really hoping someone can help me this because I am about to lose my ever loving mind after trying every variation I kind think of to make this work. I really don't understand why Microsoft makes working with dates such a PITA.

I have a sharepoint list with a date only column that apparently returns the format as yyyy-mm-dd from what I can see in the output.

In flow I am pulling the items from the list and then attempting to filter an array by that field. I simply want to filter anything that has today's date. That's it. I have been trying variations of formatdatetime and convertfromutc without getting a successful run. I thought formatdatetime would do it, but then it appears in UTC that it is still doing something funky because I get outputs like 2020-56-06 hence why I tried to use convertutc in conjunction with it. Any help would be greatly appreciated to keep my sanity. Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,981 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

I will explain how to filter the dates using formatDateTime expression. Here are the details.

Below is my SharePoint list.

Above I have three records in my list. Next I am going to filter the StartDate against todays date.

Here is my flow configuration

Above under the filter query I am using the below expression

formatDateTime(utcNow(),'yyyy-MM-dd')

Note: Place the formatDateTime expression under single quotes.

Here is my run result and returned two records which matched todays date.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks I am closer as at least it isn't erroring, but is not returning any results either. The odata query I have is

Modified eq 'formatdatetime", the syntax used for formatdatetime is what you gave me as formatDateTime(utcNow(),'yyyy-MM-dd').

I have one result it should return, just modified it today to change the marker, but all I get in output is

{
"value": []
}
Any ideas?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I think I got around it. It appears to be something specifically with the modified field. If I create a custom date only sharepoint field then your logic works.

Was this reply helpful? Yes No