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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract entity from em...
Power Automate
Answered

Extract entity from email to update dataverse

(0) ShareShare
ReportReport
Posted on by 82

Hi all, 

 

I have a flow that use 2 AI builder (custom category classification model and Entity extraction custom model). 

The flow triggered by reading incoming email that contain a certain keyword in the subject, email subject that matched the criteria will be transform from html to text in the flow. 

Then, the Custom Category Classification model will analyze the text and classify the provided text. The Entity Extraction Custom model will need to identify two types of information (Ref ID and CountryPostalCode) in the flow.

After these steps, the flow will need to update a Dataverse table according to the Ref ID. (Ref ID is actually the unique identifier from the Dataverse table). 

The challenge that I faced with is that I couldn't filter to update with only a specific row in the Dataverse table. I will only be needing to use Ref ID to filter my dataverse table. I tried to filter with the Dynamic Content of 'Entity Value' but that will count the CountryPostalCode as value too and causing my flow failing. 

How do I get the flow to filter only Ref ID so it can update my Dataverse table. Below attached my flow as a reference. 

 

Thank you. 

Xinlin_0-1673407052722.png

Xinlin_1-1673407147389.png

Xinlin_2-1673407270817.png

Xinlin_3-1673407321544.png

Xinlin_4-1673407386150.png

Xinlin_5-1673407434787.png

 

Categories:
I have the same question (0)
  • Verified answer
    CedrickB Profile Picture
    Microsoft Employee on at

    If I understand properly your case, in the "List rows" step enter for "Filter rows" an expression like this one

    your_technical_lower_case_ref_id_field_name eq ExtractRefID

    Where your_technical_lower_case_ref_if_field_name should be something like

    cbr59_refid

    You can find this editing the table's columns in Power Apps portal.

  • Xinlin Profile Picture
    82 on at

    It works, thank you! 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 568

#3
Haque Profile Picture

Haque 538

Last 30 days Overall leaderboard