Unanswered

ayuda cuántas veces se repite cada registro

(0) Share

Report

Posted on by Yeferson_Nova

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No