Send survey with power automate with dynamically selecting surveys and templates

(0) Share

Report

Posted on by MMK

745

Hi Guys,

How can we set the survey and Templates in Power automate like setting any other lookup values

What to give in the field "The fields to send to WebMerge"

i tried to set surveys and templates dynamically like any other lookups but it is giving error
"

Newtonsoft.Json.JsonSerializationException: Required property 'EmailTemplateId' not found in JSON. Path '', line 1, position 98.\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.GetDataFromQuery(HttpRequestContext requestContext)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<ParseRequestData>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<DoValidate>d__11.MoveNext()

"
Thanks

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Welly Lee Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

MMK Please use the following table/field to dynamically select survey and email template:

When using dynamics property for survey, you will need to use webmerge to specify survey variables in JSON format. For example: "{"locale":"<LOCALE>","orgName":"<NAME>"}" where <LOCALE> and <NAME> is the variable value.

Please send us an email at customervoice@microsoft.com if you still experiencing issue.

Welly

Was this reply helpful? Yes No
MMK 745 on at

Like (0)

Report
Copy link

Link copied!

Hi @welly lee

Thanks a lot for quick response that really worked well.

Was this reply helpful? Yes No
deeprime 30 on at

Like (0)

Report
Copy link

Link copied!

I am getting this error.

{"ErrorMessage":"System.Exception: Form name is null\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<ParseRequestData>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<DoValidate>d__11.MoveNext()"}

My input is

{

"host": {

"connectionReferenceName": "shared_microsoftformspro",

"operationId": "sendSurvey"

},

"parameters": {

"to": "drm@xyz.com",

"ProjectId": "d486a68f-5c03-4955-9064-7596dc4565d0",

"FormId": "mNYAevvD_U21UFiVhv5gIZABYwonNOVEoiUixOl-VVdUNERITjZGTUdZRkUySExNUjgzRzFDTkdDWS4u",

"EmailTemplateId": "ea42b20b-7304-48be-bc51-94a749500f58",

"Regarding": "contact,1b145225-22d9-40e5-9331-8393ca06fe94",

"RecipientInfo": "contact,1b145225-22d9-40e5-9331-8393ca06fe94",

"firstName": "Dee",

"lastName": "Met"

}

}

Was this reply helpful? Yes No
SPART_ 25 on at

Like (0)

Report
Copy link

Link copied!

It doesn't seem like this works with the out of the box Customer Voice App that is attached to dynamics. The default flow causes the same error but I can't find the additional tables you have noted above.

{"ErrorMessage":"System.Exception: Form name is null\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<ParseRequestData>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at

Was this reply helpful? Yes No
Suggested answer

Sanjay Kasat Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please reach out to customervoice@microsoft.com with details. We should be able to resolve the issue.

Was this reply helpful? Yes No
nksse 43 on at

Like (0)

Report
Copy link

Link copied!

Hi

I've tried this approach and am getting odd failed errors when sending the survey.

My survey has these personalisation variables:

And here is the send survey node:

I get this error:

{

"ErrorMessage": "Microsoft.FormsPro.Shared.Common.InvalidFormIdException: Source array was not long enough. Check srcIndex and length, and the array's lower bounds. ---> System.ArgumentException: Source array was not long enough. Check srcIndex and length, and the array's lower bounds.\r\n at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array destinationArray, Int32 destinationIndex, Int32 length, Boolean reliable)\r\n at Microsoft.FormsPro.Shared.Common.FormIdEncoder.ExtractOrgIdAndAccountCode(String id, Guid& orgId, Guid& accountCode, String& tableId, Dictionary`2& moreInfo)\r\n --- End of inner exception stack trace ---\r\n at Microsoft.FormsPro.Shared.Common.FormIdEncoder.ExtractOrgIdAndAccountCode(String id, Guid& orgId, Guid& accountCode, String& tableId, Dictionary`2& moreInfo)\r\n at Microsoft.FormsPro.Shared.Common.FormIdEncoder.ExtractOrgIdAndAccountCode(String formId, Guid& orgId, Guid& accountCode, String& tableId, OwnerType& ownerType)\r\n at Microsoft.FormsPro.Shared.Common.FormIdEncoder.GetFormProperties(String formId)\r\n at Microsoft.FormsPro.Shared.SurveyOwnershipStore.SurveyOwnerStorageHelper.<GetLatestFormIdAsync>d__4.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.Helpers.FormsApiHelper.<GetUrl>d__7.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at Microsoft.Forms.Pro.ApiFacade.Helpers.FormsApiHelper.<FetchForms>d__12.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<ParseRequestData>d__13.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Forms.Pro.ApiFacade.RequestHandlers.SendEmailsForFlowRequestHandler.<DoValidate>d__12.MoveNext()"

}

I even get that error if I remove all the personalisation data from the WebMerge field.

Any help would be greatly appreciated!

Was this reply helpful? Yes No