Using Power Automate Zendesk connector to create Ticket from Microsoft Forms - Responder as Ticket Requester
AnsweredHello was hoping that someone can assist with this. I am very new to using Power Automate.
I have been able to get to the point where when a Microsoft Form is Submitted it will create a Zendesk ticket in the group_id that I want.
What I can't do is have the ticket created as from the Responder's e-mail. Is anyone able to assist with this?
Thanks,
Sarah
-
Hey Sarah,
I'm not familiar with the the Power Automate integration with Zendesk so I'm afraid I won't be much help in this area. It looks like this integration was created my Microsoft so it may be worth reaching out to them for assistance. I was able to find their integration page that may also point you in the right direction: Power Automation ZendeskI hope this helps!
-
Were you ever able to resolve this? We are running into the same thing with Power Automate. It seems the Zendesk Connector is quite limited. All of our tickets are getting created with our connector account (SVC-Zendesk) as the requester, not the staff user.
Thanks,
Chris
-
I too am trying to accomplish this but haven't been able to figure it out yet. If the ticket cannot be submitted by the end user can the form filler at least be CC'd on the ticket?
-
Paul Storic - I was able to resolve this.
All I'm doing is passing the 'Created By Email' in as 'requester':
-
Thanks for sharing your solution, Chris!
-
Chris Green can you show us the full flow? I don't know exactly what you did to make it work :(
Did you use a custom component?Tks!
-
Power Automator - which specific part are you trying to get to work? Passing in the requester?
All you need to do is pass the email address into the following in the API call:
"requester": "myemail@gmail.com",
-
You would just use the 'email_ccs'
-
Long shot on this but Chris, you aren't using the Zendesk Premium connector, right? I assume you are using HTTP Post method to
api/v2/tickets right?
-
Not sure if folks are still trying to figure this out, but I was able to get it to work by adding a step to GET the Zendesk user_id filtering by email address, and then submitting the ticket with the user_id as dynamic content. So the most simple flow would be:
- Trigger at form submission
- Get form responses
- Get Zendesk user_id filtering by email eq 'respondent's email'
- Submit ticket with the user_id from step 2 as requester_id
Happy to fill out more details if folks are still interested.
-
Thanks for sharing that answer, Samuel!
-
Samuel Geonetta-Trihus - I'm trying to accomplish the same thing but I can't get it to work. Could you please share more details on the four steps you are suggesting? I couldn't attach pictures to this comment but I uploaded them to my OneDrive here: Power automate.
My main issue is to get the requestor for the ticket as per the respondent's email. What should be put as the requester_id?
Thanks in advance.
-
Hrm I can't get the image uploader to work here either...
The requester_id field should just be the Zendesk "id" field - the top one in your screenshot.
The only other thing that I noticed I was doing that you are not currently doing in your Zendesk Get items query is to enter the following into the "Select Query" box at the bottom:
id
You do also need to be sure that an end-user exists in your Zendesk account whose email is an exact match to the email address of the form submitter.
Let me know if that makes sense. I can try to share some screenshots too via OneDrive if that would help.
Please sign in to leave a comment.
13 Comments