cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yeferson_Nova
Level: Powered On

ayuda cuántas veces se repite cada registro

Hola, saludos a todos me pueden ayudar, estoy tratando de obtener la cantidad de veces que se repite un registro en columna.
Tengo una lista de Sharepoint que tiene una columna de correo electrónico y necesita saber muchas veces se repite cada registro y cual es correo electrónico que menos se repite.
He tratado con una tabla y contar, pero no logro hacer que cuente para cada registro.

2 REPLIES 2
EricLott
Level 10

Re: ayuda cuántas veces se repite cada registro

How big is your dataset? You could use Flow (Power Automate) to loop through the data and increment a variable every time an email address matches. I would only recommend this for smaller datasets.

Microsoft v-siky-msft
Microsoft

Re: ayuda cuántas veces se repite cada registro

Hi @Yeferson_Nova ,

 

Do you want to know the times of repetition of each email?

Please try this formula:

 

ClearCollect(MyCollection,AddColumns('SP list',"repetition","")); ForAll('SP list',Patch(MyCollection,LookUp(MyCollection,ID='SP list'[@ID]),{repetition:CountRows(Filter(MyCollection,email='SP list'[@email]))}))

 

The repetition column of Mycollection shows the repetition time of each record.

Best regards,

Sik

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,783)