cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gcuajs
Helper I
Helper I

Calculate the count of email address in an Excel sheet

Hi,

 

I have a excel sheet which has one column with email address .I need to find the count of the email address  present in the Excel file.

 

The file contains data from Jan - Dec and each employee email address can come multiple times. We need to determine how many time an employee email Id is present and based on that we need to send different kinds of email.

 

The count can be 1,2,3 over a period of one year.

 

How can I find the count of email address in Excel file in Sharepoint. 

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @gcuajs ,

 

Please try the following method:

8.PNG9.PNG

Feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
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
ChristianAbata
Super User II
Super User II

hi @gcuajs  please follow my example, see filter array gets just the values equals to a certain mail value, then lenght counts it

 

idw.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

ChristianAbata,

 

I cannot hard code the email address .The Excel sheet has data for all the employees..

 

The Excel data is like below-:

adb@gmail.com

adb@gmail.com

bcc@gmail.com

efd@gmail.com

efd@gmail.com

efd@gmail.com

 

Data I want is 

 Email                   Count

adb@gmail.com  2

bcc@gmail.com  1

efd@gmail.com  3

 

 

 

@gcuajs  the only way is hardcodig the email in filter and use multiple options for multiple users my friend. This can me made using swich control see

 

switch.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Anybody help?

 

Hi @gcuajs ,

 

Please try the following method:

8.PNG9.PNG

Feel free to let us know if you have any questions.

 

Best Regards,

Community Support Team _ Barry
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

Users online (48,374)