cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Send Forms survey when a project in Project Online is completed

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:

screensh0.png

 

Please, any advice is much appreciated

 

Thanks in advance!

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Send Forms survey when a project in Project Online is completed

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.

Highlighted
Frequent Visitor

Re: Send Forms survey when a project in Project Online is completed

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

Highlighted
Frequent Visitor

Re: Send Forms survey when a project in Project Online is completed

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.

"

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

"

Highlighted
Frequent Visitor

Re: Send Forms survey when a project in Project Online is completed

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"
}

 

 

screensh2.png

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.

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (7,367)