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 :
Power Automate - Building Flows
Unanswered

When a row is added to dataverse tbl, search another dataverse table for similarity based on 3 column values

(0) ShareShare
ReportReport
Posted on by 2

I was wondering what everyone's thoughts might be on how to approach or solve this scenario. 

 

I have an email inbox that receives pdf invoices,  I extract fields from the invoice document to a table called "Invoices". I would like to then attempt to match the Invoice to the purchase order table, If I cannot match exactly, I'd like to find the highest similarity score based largely on 3 values being most similar (ideally expressed as a percentage).  2 of the 3 fields are text fields (vendor name, and description) and last of the 3 fields is a number value.   ( Ideally expressed as a percentage but whatever, I'm desperate) 

 

 Here's a picture of a fake mock-up if it helps 

 

Dholliday_0-1697401309394.png

 

I have the same question (0)
  • Dholliday Profile Picture
    2 on at
    Re: When a row is added to dataverse tbl, search another dataverse table for similarity based on 3 column values

    All good,  I figured it out

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 691 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 431 Moderator

#3
developerAJ Profile Picture

developerAJ 266

Last 30 days Overall leaderboard