web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Flow filter for Sharep...

Power Automate - Building Flows

Unanswered

Flow filter for Sharepoint list & blank date

(0) Share

Report

Report

Posted on by Laura3

71

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?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Ellis Karim 11,469 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

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 647 Super User 2025 Season 2

#2

Tomac 350 Moderator

#3

developerAJ 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans