Answered

Text input email validation

(0) Share

Report

Posted on by dRautela_1234

Need your help!. Currently working on a flow on Power automate desktop that requires a user to input their email address correctly using display input dialog action. I know that there are several posts related to this but I could not find any that had the same issue that I am finding. The problem is that I want to check the condition -whether the input email contains @ and .com, Once the condition satisfied, the input email should be print in an excel file.

Sorry if this has been answered already, I am very new to power automate desktop and have been relying on this forum for many of the quirky issues that I have been running into. Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PetrosF-MSFT Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dRautela_1234

You could use the "IF" actions to check if this condition is met. For this scenario, we would need two (2) IF actions the one embedded into the other.

If the character "@" is contained into %UserInput%, then If the text ".com" is contained into %UserInput%, then write the email to the Excel file.

I hope the above helps!

Was this reply helpful? Yes No
dRautela_1234 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @PetrosF-MSFT ,

I got your point but my concern is for eg. a prompt appears to input the email id into $userinput$ variable. I want to ask for a prompt until it meets the conditions i.e. does not contains @ and .com. so how can I use the loop while condition on that basis?.
As you suggest if condition, it will work for only one time but I want to iterate till it meets both the condition & sometimes what happen user input for eg. these below three inputs.
1. abc@
2. afbjsbvjsb
3. abc.com

Was this reply helpful? Yes No
Verified answer

PetrosF-MSFT Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @dRautela_1234

In that case, you could add all the actions inside a "loop condition" which will always be true (eg. 1=1).

Additionally, inside the embedded "IF" condition, you can add an "Exit loop" action to exit the loop only if both IF conditions are met.

I hope the above makes sense.

Was this reply helpful? Yes No
dRautela_1234 71 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, @PetrosF-MSFT ,
Thanks for the solution. It worked to some extent. 🙂

Was this reply helpful? Yes No