Yes! We missed you Jon! Also, I recently did this exact same thing to combine a Dynamics business process flow with JotForm. So Dynamics generates a unique code, like Acct1000010, and a hyperlink to the form with that unique code to pre-fill. So people working through the process can share the link generated in the process with the partner, the partner can fill the form, and on submit the response data automatically fills in the Dynamics fields for the record that has the unique Acct1000010 form code and uploads a PDF of the responses & signatures to the SharePoint folder associated with that account.
@@JonJLevesque Yes, some staff at my org really like docusign, but I believe JotForm has more form options and they gave us an account with unlimited submissions for free while we were building application processes for COVID relief during the pandemic.
Help please. Any suggestions would be greatly appreciated. My flow is not being triggered. I followed the example the best I could. Everything seems to working properly, with the exception of the flow not being triggered, when a Google Form response is submitted.
I don't know where he found this ID, because if you look at the ID of his form, it's not the same as the one in the script, not even the ID that appears in the docs.google domain
@@JonJLevesque sad, but on the other side (I am not very technical) is there a way Microsoft From can have a URL with ex. ID of Client? that will allow me to pull out data afterwads and match with item in SP list?
Hi Jon, why didn’t you all just use something like this code below to get a normal JSON body response in the flow? I tested it and it works fine. Seems like it would avoid headaches with the manual parsing of each key-value in the flow. function setUpTrigger(){ ScriptApp.newTrigger('sendPostRequest') .forForm('InsertFormIdHere') .onFormSubmit(); } function sendPostRequest(e){ var form = FormApp.openById('InsertFormIdHere') var responses = form.getResponses() var formDataLast=responses[responses.length - 1] var formData=formDataLast.getItemResponses() var sendData ={} sendData["email"] = formDataLast.getRespondentEmail(); //var emailUser = {"email":formDataLast.getRespondentEmail()} //sendData.push(emailUser) for(var k=0; k
Hi, thanks for this. I've tried it, and the output looks great and is easier to work with. However, I'm experiencing something and would appreciate your insight. I've set up the script, debugged and ran it. But the trigger somehow doesn't automatically work. It only runs when I manually go to click Run at the top pane. Isn't this meant to be automatic and run every time there's a new response? Manually clicking Run every time to call the flow URL would not be very efficient. Please would you know what's causing this and how I can get it fixed? Many thanks.
I am unsuccessful in getting the submitted Google Form to route its form response data over to my Power Automate workflow (via UrlFetchApp.Fetch). I have *triple* checked everything, and this definitely is not working. I have the google script created, it matches exactly except of course the Google Form ID (2 places) and the "When an HTTPS Request is received" HTTP POST URL value. I have this all setup using my personal Google account. One thing I wonder is nowhere in this video, or in another writeup I found from the same speaker, mention about "Deploy" in the Apps Script editor. Question: Does this need to be deployed before this connectivity to Power Automate works? If a Deploy needs to happen, which type of Deploy (4 options), and what are the values I must supply? I think I am running into what Hassan asked about in the conversation thread here (cannot get 2nd part working). Please help. thanks
I also have trouble with that last "UrlFetchApp.fetch" step - that second "When a HTTP request is received" flow didn't start at all. Did you solved it somehow?
Yes! We missed you Jon!
Also, I recently did this exact same thing to combine a Dynamics business process flow with JotForm.
So Dynamics generates a unique code, like Acct1000010, and a hyperlink to the form with that unique code to pre-fill.
So people working through the process can share the link generated in the process with the partner, the partner can fill the form, and on submit the response data automatically fills in the Dynamics fields for the record that has the unique Acct1000010 form code and uploads a PDF of the responses & signatures to the SharePoint folder associated with that account.
Awww Thanks Tyler. I appreciate you saying so :)
That's a very cool setup with Dynamics! That process would plug into DocuSign super well too LOL ;)
@@JonJLevesque Yes, some staff at my org really like docusign, but I believe JotForm has more form options and they gave us an account with unlimited submissions for free while we were building application processes for COVID relief during the pandemic.
It's Good to have your videos on power automate. Your videos have helped me automate many of my small business problems. Thanks a lot again Jon
Haha! You're very welcome my friend! Thanks for taking a moment to leave a comment :)
Haven't seen Jon for a while. Nice to see you at work again with the Power Platform!
Is this possible to do with Microsoft Forms now that they offer prefilled form options?! 😀
Great will this require me to like re authorize the script often or once set its done
You may need to refresh auth once in a while but it should be based on your internal limits
Help please. Any suggestions would be greatly appreciated. My flow is not being triggered. I followed the example the best I could. Everything seems to working properly, with the exception of the flow not being triggered, when a Google Form response is submitted.
2nd part of flow is not running from the script. What can i do?
I don't know where he found this ID, because if you look at the ID of his form, it's not the same as the one in the script, not even the ID that appears in the docs.google domain
Hi Jon :) What about Microsoft Forms? Can they be pre-filled?
Nah, as stated in the video. It’s not possible :(
@@JonJLevesque sad, but on the other side (I am not very technical) is there a way Microsoft From can have a URL with ex. ID of Client? that will allow me to pull out data afterwads and match with item in SP list?
🙁This requires premium actions in Power Automate.
Licenses are cheap!
Hi Jon, why didn’t you all just use something like this code below to get a normal JSON body response in the flow?
I tested it and it works fine. Seems like it would avoid headaches with the manual parsing of each key-value in the flow.
function setUpTrigger(){
ScriptApp.newTrigger('sendPostRequest')
.forForm('InsertFormIdHere')
.onFormSubmit();
}
function sendPostRequest(e){
var form = FormApp.openById('InsertFormIdHere')
var responses = form.getResponses()
var formDataLast=responses[responses.length - 1]
var formData=formDataLast.getItemResponses()
var sendData ={}
sendData["email"] = formDataLast.getRespondentEmail();
//var emailUser = {"email":formDataLast.getRespondentEmail()}
//sendData.push(emailUser)
for(var k=0; k
Hi, thanks for this. I've tried it, and the output looks great and is easier to work with.
However, I'm experiencing something and would appreciate your insight.
I've set up the script, debugged and ran it. But the trigger somehow doesn't automatically work. It only runs when I manually go to click Run at the top pane.
Isn't this meant to be automatic and run every time there's a new response? Manually clicking Run every time to call the flow URL would not be very efficient.
Please would you know what's causing this and how I can get it fixed?
Many thanks.
I am unsuccessful in getting the submitted Google Form to route its form response data over to my Power Automate workflow (via UrlFetchApp.Fetch). I have *triple* checked everything, and this definitely is not working.
I have the google script created, it matches exactly except of course the Google Form ID (2 places) and the "When an HTTPS Request is received" HTTP POST URL value.
I have this all setup using my personal Google account. One thing I wonder is nowhere in this video, or in another writeup I found from the same speaker, mention about "Deploy" in the Apps Script editor. Question: Does this need to be deployed before this connectivity to Power Automate works? If a Deploy needs to happen, which type of Deploy (4 options), and what are the values I must supply?
I think I am running into what Hassan asked about in the conversation thread here (cannot get 2nd part working).
Please help.
thanks
I also have trouble with that last "UrlFetchApp.fetch" step - that second "When a HTTP request is received" flow didn't start at all. Did you solved it somehow?