web

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

News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Do not send mail if Sh...

Power Automate - Building Flows

Answered

Do not send mail if SharePoint field is empty

Like (0) Share

Report

Report

Posted on 11 Aug 2020 14:35:06 by Frankie70

384

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:

But it fails. Is the syntax correct?

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Verified answer

v-litu-msft on 12 Aug 2020 at 07:58:27

Like (0)

Report

Re: Do not send mail if SharePoint field is empty

Hi @Frankie70,

The Outcome should be dynamic content:

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

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.

Was this reply helpful? Yes No
Frankie70 384 on 11 Aug 2020 at 17:37:47

Like (0)

Report

Re: Do not send mail if SharePoint field is empty

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.

The syntax of my other issue is:

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on 11 Aug 2020 at 17:19:40

Like (0)

Report

Re: Do not send mail if SharePoint field is empty

@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

Was this reply helpful? Yes No
Frankie70 384 on 11 Aug 2020 at 15:36:30

Like (0)

Report

Re: Do not send mail if SharePoint field is empty

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...
Where is the problem here?
At start it worked all perfectly...all of a sudden, if throws this error. Any idea?

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on 11 Aug 2020 at 15:07:17

Like (0)

Report

Re: Do not send mail if SharePoint field is empty

@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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Responsible AI policies for the Community

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans