web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : tGLyZ43CO5/auwfkUc69NS
Power Automate - General Discussion
Unanswered

Show similar records by match rate

Like (0) ShareShare
ReportReport
Posted on 2 Jan 2023 03:37:22 by 3

Hi 

I am trying to create a page which will show similar records by match percentage of the current record i am viewing.

Example;

 

In dataverse we have a table called 'USER DATA' with the following fields: [NAME, REF, APP_NO, APP_DATE, EMAIL]

 

NAME REF APP_NO  APP_DATE EMAIL
JOHN SMITH 12345 APP12345 

12/12/22 

J.SMITH@MSN.COM
J SMITH12344

APP12345

12-12-2022J.SMITH@MSN.COM
JOHN JOE SMITH12345APP1234413-12-22J.SMITH@MSN.COM
JJ SMITH12333APP1234512-12-2022J.SMITH@MSN.CO
BRUCE WAYNE43455APP54542-2-2022BRUCE_WAYNE@GMAIL.COM
B WAYNE43455APP545452-2-2022BRUCEWAYNE@GMAIL.COM
TOM RIDDLER55334APP1234442-5-2021T.RIDDLER@MSN.COM
JACK SPARROW12345APP545322-5-2021J.SPARROW@GMAIL.COM
MICHAEL JORDAN4445555APP444333312-3-2021MJORDAN@HOTMAIL.COM

 

As you can see the 'J smiths' there are duplicates and so it 'Bruce Waynes' as they have similar 'Ref, App_no,App_date or Email' with some typos in the email or ref etc.

 

So in a canvas app if i am viewing the first Item:

JOHN SMITH 12345 APP12345 

12/12/22 

J.SMITH@MSN.COM

 

It should also give me similar records with match rate/percentage on string match(reduce to all lower case then do string match) eg:

 

NAME REF APP_NO  APP_DATE EMAILMATCH%

j smith

 

Match: 

82.35%

12344

 

Match:

80%

app12345

 

Match:

100%

12/12/22

 

Match:

100%

j.smith@msn.com

 

Match:

100%

92.47%

 

Calculations= (82.35+80+100+100+100 )/5 

john joe smith  

 

Match:

83.33%

12345

 

Match:

100%

app12344

 

Match:

87.5%

 

13-12-22

 

Match:

62.5%

 

j.smith@msn.com

 

Match:

100%

86.66% 

jj smith

 

MATCH:

77.78%

12333

 

MATCH:

60% 

app12345

 

MATCH:

60%

12-12-2022

 

MATCH:

66.67%

j.smith@msn.co

 

MATCH:

96.55%

72.2%

 

 

Which can be shown on a new tab titled 'Similar records' 

 

Is there a way to do this or a better way to do this as theres going be to a big data involved over 1 million rows?

 

Thanks

Zizu

 

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2