Customer Voice - Getting Data into new entities

[sibi]

Hi All,

With the new move from Forms Pro to Customer Voice, some of our flows will need updating. Unfortunately, we are running into the below.

Previous Situation:

- Survey is completed

- Flow checks if Forms Pro Survey Response is created

- Using the Get Response Details step, we mapped the fields from the survey to the fields in a custom entity

- An example would be, question what is your satisfaction rating? We would populate the Customer SAT Score field in the new Customer SAT record we are creating with this information. 

Current Situation:

- There is no more Get Response Details step for Customer Voice

- When a survey is complete, a Forms Pro Survey Response is still being created

- Customer Voice Survey Questions are created for each survey. These are records that correspond the every question in every survey. If you have 2 surveys of 4 questions each, there will be 8 associated records.

- Customer Voice Survey Question Reponses records are created as answers to the above. If surveys are responded too, each Customer Voice Survey Question will have multiple Customer Voice Survey Question Responses. 

My question is, how can I take the values in the Customer Voice Survey Question Response and map it to a custom entity I have created? 

The above might not be clear, so a tl;dr is any advice working with Customer Voice and Power Automate to make the data more presentable in Dynamics 365 would be greatly appreciated.

Thanks!

Regards,

SS

[ppp345678]

Forms response will be stored in the specified entity in Common Data service. Maybe you can create a relationship between this entity and the custom entity you mentioned.

[MMH117]

You can trigger your power automate flow on create of the survey response in the CDS. Then your flow can get the related question responses for the survey and filter to get the values you need. After you have the values, you can store them in your custom CDS entity.