Find GUID from Description

[Elzoolio]

Hi,

Using Dataverse

I have an email that comes in with a Description.

The table is C_Location

The field is Description

How, in a flow, would I obtain the GUID based off the description that comes in?

Thank you!

[v-yujincui-msft]

Hi @Elzoolio ,

Do you want to extract a field value from an email and then look up a corresponding record in Dataverse?

I have made a simple test for your reference.

trim(split(split(replace(replace(outputs('Html_to_text')?['body'],decodeUriComponent('%0A'),''),' ',''),'delimiter1')[1],'delimiter2')[0])

outputs('List_rows')?['body/value'][0]['Schemaname']

Result Screenshot:

In addition, here is a link for your reference.

Solved: Creating Outlook Event From Automated Email - Power Platform Community (microsoft.com)

Best Regards,

Charlie Choi

[Elzoolio]

Hi @v-yujincui-msft ,

I’ve parsed the email and set the individual lines using Compose for the Description.

It can pull that from the without a problem and I have the content I need. They are typically city names prefaced with some information and I utilize this dynamic value elsewhere in the flow to populate a new row.

XXX-Sacramento is an example.

What I would like to do is look at the table(C_Location) that Description comes from and obtain the GUID for that specific record(XXX-Sacramento). From the C_Location table there is a row with a description XXX-Sacramento.

Obtain the GUID.

Thanks for the reply!