Power Automate

Connecting eMail table with Ticket table

(1) Share

Report

Posted on by L.Nassiri

Hello everyone,

I am currently creating a model-driven app.

It consists of an eMail Massages table and a Tickets table.

I have a Power Automate Flow that creates a row in the eMails table when an email is received in a shared mailbox, after that a row in the Tickets table so that a ticket ID is created.

My problem is to append the generated ticket ID to the email. When I try to write the Ticket-ID from Tickets back to the lookup field Ticket-ID in the table Email, it throws this error:
URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL.

I have also tried to work with subgrids in table tickets, but since I don't have a reference value ticket ID, I can't filter the mails that are displayed.

Do you have any idea how I can link my incoming emails to the Tickets list? A direct entry in the list is not possible as the body of the emails usually have more than 4,000 characters and exceed the maximum number of characters in a field.

I look forward to your ideas!

Laalak

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Ok let me start. So many folks bring their issues here which is wonderful, but don't actually share their flows. Its really hard for us to help folks quickly or at all when you just share an error. Please make sure to share your flow, your flow run failed, inputs outputs etc so we can help you easier.

Now that being said, your issue is:

1. You are either NOT using the proper format for the lookup

2. You have a bad GUID in there.

You need to make sure that you are doing this

/pluralschemaname(GUID) without quotes

So if you created a Table called Foo and if your Published for that solution gives you a prefix of my_ then in your flow you would do this.

1. Create your Ticket

2. Now in your Update Email thingee or whatever table, you will put this in your LookUp

/my_foos(DynamicUniqueIDFromFoo, which will actually BE the dynamnic property called Foo)

/my_foos(Foodynamicpropertyfromemailrecord)

Cheers

Was this reply helpful? Yes No
L.Nassiri 3 on at

Like (0)

Report

Hello Michael,

Thank you for your reply and sorry for the missing screenshots :-)

I am quite new to Power Automate. Could you please tell me where I can write this?

Here is the flow:

And this is the field in eMail which should be filled with the Ticket-ID from the Ticket-List

Outputs(‘Get_a_row_by_ID_-Tickets’)?[‘body/ln_ticketid’]
I think I have to change the Tickets to the shema name ln_ticket but where can I do this?

Thank you very much! Laalak

Was this reply helpful? Yes No