Answered

If Expression within an e-mail

(0) Share

Report

Posted on by MMPowerAutomate

I have entered a Forms response, which could be empty depending on the response. How do I write a condition that if it is empty it should show "/" instead of being blank when receiving an e-mail? In my case this is the response "Country" which comes from Microsoft Teams.

Categories:

General topics

All responses (7)

Answers (2)

Sort by

Verified answer

grantjenkins 11,063 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

NOTE: I noticed in the body of your email you have Please enter your Last Name twice. Was one of these supposed to be for First Name?

The flow below should work if your Country field in MS Forms is of type Choice or Text.

The flow adds a variable to hold the final output of Country. It then uses a condition to check if the user entered/selected a Country or not. If they did then it sets the Country variable to the actual Country, otherwise it sets it to /

You can then use the Country variable within your email.

See flow below:
MMPowerAutomate 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply. Yes, it is a text. Unfortunately I am still getting empty e-mail and I do not see the "/".
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@MMPowerAutomate ,

Please replace the condition

with
MMPowerAutomate 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi SudeepGhatakNZ

The moment I do that, I get following message and the flow does not work.
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

HI @MMPowerAutomate ,

That error does not seem to be related to this change. Are you able to show me your expression?
grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

This error can happen when you are building the flow and you add an action that requires a connection you haven't used in the flow yet and you just click Test.

If that's the case, then you'll need to actually Run the flow which will prompt you to either authenticate with an existing connection you already have or create a new one. After that just clicking on Test will work fine.

How did you go with the actual condition and showing /
MMPowerAutomate 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @SudeepGhatakNZ and @grantjenkins , both solutions worked. The problem was that in the last step (e-mail outlook) I did not select the newly defined name of the variable, but the output from the survey, which led to an error.