web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps ayuda cuántas veces se...

Power Apps

Unanswered

ayuda cuántas veces se repite cada registro

(0) Share

Report

Report

Posted on by Yeferson_Nova

1

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation