cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User II
Super User II

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

hello @manuelstgomes 

but i cant see the "Edit in advanced mode"

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

Hello @manuelstgomes 

this is not working properly

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

thanks for your help

 

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

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

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

Hello @manuelstgomes 
this is the error message

Silas7100_0-1597825670377.png

 

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

@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

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

@manuelstgomes 
yes this is the condition that i send.

 

 

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

thanks for your help

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (45,840)