Unanswered

Flow filter for Sharepoint list & blank date

(0) Share

Report

Posted on by Laura3

Hi there,

I am very new to flow and I wonder if someone could help with this 'simple' query. I'd like to create a flow to update a sharepoint list. My list (list of projects) has a field EndDate. I'd like to automatically update the field called ProjectStatus to 'Open' when the EndDate is greater than today or 'Closed' when the EndDate is smaller than today or the EndDate is blank. I'm able to do the first two, but I can't seem to get it working for the case where EndDate is blank. I have tried EndDate is equal to null, but that doesn't work. Empty doesn't work either, '' doesn't work either. Any idea?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Ellis Karim 11,653 Super User 2025 Season 2 on at

Like (0)

Report
Re: Flow filter for Sharepoint list & blank date

Hi @Laura3 ,

Can you share your expression for the ProjectStatus.

For the expression you can try the following:

if(empty(outputs('EndDate')), 'Closed', if(greater(outputs('EndDate'), utcNow('yyyy-MM-dd')),'Open','Closed'))

EndDate should not contain the timestamp, only yyyy-MM-dd

Also, what happens if EndDate is equal to today?

Hope this helps.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Laura3 71 on at

Like (0)

Report

Re: Flow filter for Sharepoint list & blank date

Thanks for responding. So I have a flow that starts with a manual trigger (I'm still experimenting it will be scheduled once I know it works). Then I have a 'get items' where I fetch the data source, then I have inserted a condition. I'd like to have the EndDate is less than uctNow or is blank. If that condition is met, I have an update item that simply updates the project status to Closed. If the condition is not met, it updates to Open. It works fine when there is a date in EndDate but not where there is a blank.

Was this reply helpful? Yes No