Answered

Finding duplicates in a gallery - Dataverse for Teams as datasource

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all, I've upataded the below question.

I'm trying to highlight items in a gallery that have duplicate values in certain fields (the app is built in teams with Dataverse for Teams as the datasource). Unfortunately, I am not getting the correct results

For example, I have the following formula to check if there are items with the same EffectiveFrom date (timezone independent date column):

CountIf(
 THR_0001_Contracts,
 EffectiveFrom = ThisItem.EffectiveFrom
)

As you can see from the screenshot below, the results are unreliable, as the bottom two both show 9/1/2020 12:00AM but the count in the last column is 0.

I have also tried Adding a column in the Items property of the gallery but this returns the same results.

Can anyone suggest what might be going wrong here?

Thanks

Joel

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you try below code ?
Count(Filter(DataSoruce,Condition).ID)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik, thanks for your suggestion but this hasn't worked for me. I've changed my example above as I've deduced that the problem seems to be related to date columns
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

The below code worked in my case. Let me know if it helps

Count(Filter(THR_0001_Contracts,DateTimeValue(Text(EffectiveFrom ))=DateTimeValue(Text(ThisItem.EffectiveFrom ))).ID)
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Your formula does work, @PriyankaGeethik, but it doesn't delegate.

I've been using CountIf() because it supposedly delegates in Dateverse for Teams with the Enhanced Delegation for Dataverse setting switched on....but it appears that it doesn't work for date columns. I think I may need to store the date in a single line of text helper column, with which I can check for the duplicates