cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Condition Date field contains no value

Hello,
how exactly do I have to build this condition if I want to check if the date field of a SharePoint Online list contains a value?

Thanks a lot.

13 REPLIES 13
Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

Hi @Silas7100 

 

You can use the "empty" function. Here's another post that has the answer to your question:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-do-i-setup-a-check-if-sharepoint-fiel...

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

hello @manuelstgomes 

but i cant see the "Edit in advanced mode"

Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

Hi @Silas7100 

 

Indeed. You need to copy the formula to the field.

 

Can you please check if and let me know if you have any questions?

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

Hello @manuelstgomes 

this is not working properly

2020-08-18 13_44_10-Flow bearbeiten _ Power Automate.png

thanks for your help

 

Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

Hi @Silas7100 

 

The formula is not yet correct. A trick is to select, in basic mode, the field and then, in advanced mode paste it. It will write the structure like bellow "triggerBody()...."

 

Screenshot 2020-08-18 at 12.51.07.png

 

Can you please check if and let me know if you have any questions?

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

hello @manuelstgomes 
Is that right?
If the elements have a date in it and true is reported back, then it works.But if you don't have a date in it, then you get an error message, means if the condition returns false
2020-08-19 08_28_54-Flow bearbeiten _ Power Automate.png
thanks for your help

Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

Hi @Silas7100 

 

That looks correct.

 

Is there any error or it just doesn't return anything?

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

Hello @manuelstgomes 
this is the error message

Silas7100_0-1597825670377.png

 

Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

Hi @Silas7100 

 

The error is in the other Condition, not the one you send me. Can you please show me your "less" function to check?

 

Basically the error is telling you that one of the values is null. That makes me believe that the first condition is incorrect because otherwise there would be a value to compare.

 

Can you please try, in the advanced mode, putting the whole formula as above and try to see if the condition is triggered correctly?

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

@manuelstgomes 
here is the other condition.

adddays(utcnow('yyyy-MM-dd'),7, 'yyyy-MM-dd')


2020-08-19 11_43_23-Edit your flow _ Power Automate.png

Highlighted
Super User II
Super User II

Re: Condition Date field contains no value

HI @Silas7100 

 

The error doesn't match what you're doing there. Is the condition that you're sending me this one?

2020-08-19 10_47_34-Re_ Condition Date field contains no value - Power Platform Community.png

 

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

Cheers
Manuel

Highlighted
Regular Visitor

Re: Condition Date field contains no value

@manuelstgomes 
yes this is the condition that i send.

 

 

Highlighted
Regular Visitor

Re: Condition Date field contains no value

@manuelstgomes
do you have any other ideas why the flow is not working?

thanks for your help

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (8,671)