Send Forms survey when a project in Project Online is completed

[Ximo]

Hi,

we have set up a trigger in Power Automate to send a Forms survey to the Senior Users/Clients each time a new project in Project Online is completed and closed.

Each project has different Senior Users/Clients but the Forms survey is the same and we would like to be able to automate it and analyze the responses for each project. 

Currently the flow sends the survey and all the responses are registered in the same Forms survey so we cannot differentiate for which project in particular are the responses: there are cases where the same client is in two o more projects at the same time, so as per default responses information in Power Automate we only know the Responders' Email but there is no way to link it to a specific project.

How can be this achieved? We have tried using variables like ProjectID and when the survey is triggered from Power Automate we pass the ProjectID to the Forms variable and then the survey is sent. The variable is working when the survey is presented to the user but not present in the responses that Power Automate collects. Even if we use [[]] or {{}} in a hidden question with text restrictions that enables to write something in the answer field:

Please, any advice is much appreciated

Thanks in advance!

[v-alzhan-msft]

Hi @Ximo ,

Sorry for your requirement couldn't be achieved in Microsoft flow since the function to send an survey is not supported in microsoft flow currently.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ximo]

Hi Alice,

thanks for your response but according the below information Power Automate supports sending Forms Pro surveys:

https://docs.microsoft.com/en-us/forms-pro/send-survey-flow

[Anonymous]

Ximo,

Did you pass the project ID into the Regarding field? It says "associate invitation and response" so not sure if it works as designed.

"

Regarding

Record to associate survey invitation and response. This value is stored in the survey invitation's Regarding field.

"

[Ximo]

Hi Bill,

yes, we added the ProjectID in the Regarding field but with the regular Get Responses action that value is not returned so we cannot associate the response to an specific project. This is the "Get response details" body:

{
  "responder": "xim@testingtrial.onmicrosoft.com",
  "submitDate": "6/18/2020 2:45:41 PM",
  "r454c8b9b6814493590dccf07e71492fc": "3",
  "rb04b8fb2236b4da99e4bc5bee15f0182": "5",
  "r2cedb942b4cc408cbf37ff4c71a4a8c9": "2",
  "r9b6c65cf4f844f43aae24ef3beacb0ed": "1",
  "rec705baab9414c33b3327a3670cd744b": "3",
  "r8db2bda79a0c4bfcb0ccf0bd91854146": "asdfasdfasfdasdfxcvbxcvbxcbvx"
}

If the user has access to the CDS, querying by survey name enables to extract the variables in the form from the Context Data value, this is explained here:

https://meganvwalker.com/extracting-survey-variables-from-forms-pro-responses-without-access-to-cds/ 

It would be great for users without access to the CDS to get Form variables in the Response Details but no luck so far.