Excel validation for gmail id

(0) Share

Report

Posted on by Sindhu251

Hi @WarrenBelz

I am uploading excel file in powerapps using flow

I want to validate email id, if i give only @gmail.com under connect facilitator column it should not accept in flow it should say please provide full email id like example ( diyadev@gmail.com )

In my flow if i give @gmail.com it is accepting. help me to add condition it should not accept if we just give @gmail.com.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Sindhu251

Use the following expression that will return you the part before @gmail.com

first(split(outputs('Get_Email_Value'), '@'))

You could then check the length of this expression to make sure it is greater than 0

Was this reply helpful? Yes No
Sindhu251 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ ,

I want to get only email id without @gmail.com in excel under connect facilitator in one row i have 3 id's seperated by semicolon nisha@gmail.com; trisha@gmail.com; disha@gmail.com. I want to get all 3 id's without @gmail.com like nisha;trisha;disha

first(split(items('Loop_Through_Connect_Agenda_Template_Rows')['_x0023_ConnectFacilitator_x0023_'], '@'))

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Sindhu251 , Try this

Was this reply helpful? Yes No
Sindhu251 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ

Still i am getting error

Was this reply helpful? Yes No