cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frankie70
Post Patron
Post Patron

Do not send mail if SharePoint field is empty

Hi all,

I have built an approval workflow and I am stuck checking if a field from Sharepoint is not empty (if not, a mail should be send out)

I tried with Condition:

Frankie70_0-1597156455494.png

But it fails. Is the syntax correct?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Frankie70,

 

The Outcome should be dynamic content:

Annotation 2020-08-12 151747.jpg

And you could refer to the following screenshot to learn how to use empty() function:

Annotation 2020-08-12 151748.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
edgonzales
Super User II
Super User II

@Frankie70 

Hi there.  You should be able to look at past runs to see what is being sent fro SharePoint for that field.  Depending on what type of field it is, there may be something in there, just not data.  Take a look at the empty() function and see if that might be more applicable to your situation.

 

Either way, keep us posted.  Good luck!

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Hi @edgonzales 

the field is of type "multiple lines of text" so an arry.

The function empty() does not work either.

 

For some reason I have an issue before that now, and I am puzzled why...

Frankie70_0-1597160061279.png

Where is the problem here?

Frankie70_1-1597160118342.png

At start it worked all perfectly...all of a sudden, if throws this error. Any idea?

@Frankie70 

Is this an older flow?  Where you have Response for the condition, you should probably have Outcome.

 

If your other field is an array, then empty() should work.  Let's take a look at the syntax of your expression next.

 

-Ed

Hi @edgonzales 

thanks for your help.

No, this flow is quite new...

I changed it to "Outcome" but when I click on Approve or reject in the mail, it always is rejected.

 

Frankie70_1-1597167451950.png

 

The syntax of my other issue is:

Frankie70_0-1597167409321.png

 

Hi @Frankie70,

 

The Outcome should be dynamic content:

Annotation 2020-08-12 151747.jpg

And you could refer to the following screenshot to learn how to use empty() function:

Annotation 2020-08-12 151748.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (76,256)