extract subject from email replys and put them in an existing sharepoint list

(0) Share

Report

Posted on by CU12121941-0

Hi I have made an power app with email options.

the goals is that users can make a IT Ticket and i can monitor all questions and answers/solutions

1. when a user register a ticket, the information goes in a sharpoint list

2. i have a overview form where all data is shown of the ticket

3. in the overview i have an option to email to the ticket maker all communication wil be saved in a colum

now my problem is when a users response i have no trigger yet to put this respons in the right colum

i know this can be done by power automate i have googled it many times but i can't get it done.

can someone help me with a step - step tutorial?

or give me a working example?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

teylyn1 362 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I'm not sure I understand the scenario correctly. Can you explain a bit more how the system works?

How does item 3. work? How is that email to the user generated? Is it a button in a SharePoint view? or in a PowerApp?

How does the user respond? Email? if so, who is the email sent to?

Was this reply helpful? Yes No
CU12121941-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!
See image for a printscreen

Button code on select: (i have a different language)

Office365Outlook.SendEmailV2( Gallery1_1.Selected.Melder.Email; "Update over jouw ticket: " & Gallery1_1.Selected.ID_TKT; "Beste " & Gallery1_1.Selected.Melder.DisplayName & ", " & "Er is een nieuwe opmerking toegevoegd aan jouw ticket: " & txtOpmerking.Text & " " & "Met vriendelijke groet, " & "Het IT-team" );; // Voeg nieuwe e-mailinhoud toe aan bestaande inhoud in de Mail-kolom Patch( 'IT Tickets'; LookUp('IT Tickets'; ID = Gallery1_1.Selected.ID); { Mail: Coalesce(LookUp('IT Tickets'; ID = Gallery1_1.Selected.ID).Mail; "") & // Voeg bestaande inhoud toe Char(10) & Char(10) & // Voeg twee lege regels toe voor scheiding "E-mail verzonden op: " & Text(Now(); "dd-mm-yyyy HH:mm") & Char(10) & "Inhoud: " & txtOpmerking.Text } );; // Toon een succesmelding voor de gebruiker Notify("E-mail verzonden en toegevoegd aan log!"; NotificationType.Success);;

Was this reply helpful? Yes No
CU12121941-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

the employee gets an email they will respons to that email.

i want to see this response in the view as a communication list

Was this reply helpful? Yes No