cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Elzoolio
Frequent Visitor

Find GUID from Description

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!

2 REPLIES 2
v-yujincui-msft
Community Support
Community Support

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.

vyujincuimsft_0-1665650925124.png

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

vyujincuimsft_1-1665650956325.pngvyujincuimsft_2-1665650964046.png

Result Screenshot:

vyujincuimsft_3-1665651189833.png

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

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!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,976)