Condition Date field contains no value

[Silas7100]

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.

[manuelstgomes]

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

[Silas7100]

hello @manuelstgomes 

but i cant see the "Edit in advanced mode"

[manuelstgomes]

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

[Silas7100]

Hello @manuelstgomes 

this is not working properly

thanks for your help

[manuelstgomes]

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()...."

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

[Silas7100]

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

thanks for your help

[manuelstgomes]

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

[Silas7100]

Hello @manuelstgomes 
this is the error message

[manuelstgomes]

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

[Silas7100]

@manuelstgomes 
here is the other condition.

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

[manuelstgomes]

HI @Silas7100 

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

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

[Silas7100]

@manuelstgomes 
yes this is the condition that i send.

[Silas7100]

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

thanks for your help