Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Update Customer Voice ...
Customer experience | Sales, Customer Insights,...
Answered

Update Customer Voice Survey Question choices from dataverse tables

(0) ShareShare
ReportReport
Posted on by Steve McCready 5

Is it possible to update customer voice survey question choices by updating the dataverse table msfp_question with power automate. 

Context - We use Customer Voice as a Sign-In forms for events. We often have more than one event a day and want to use one survey to capture event attendees.

I created a SharePoint list with all our upcoming events, then, use Power Automate to get todays event items and to then update the field msfp_questionchoices in the table in the required format ("msfp_questionchoices": "\"Today Event 1\",\"Today Event 2\"",).

However, this does not affect the question choices on the actual survey. Is there any way to achieve this? 

  • Steve McCready Profile Picture
    Steve McCready 5 on at
    RE: Update Customer Voice Survey Question choices from dataverse tables

    Hey Bruuu,

    Thanks for the quick response.

    Thats a shame the data doesn't flow from the tables to the survey. I've tried to see if there was any chance logic or a variable based on date might work but no joy.

    I guess it's either manually updating a choice question every day or creating a choice question for every day and having a question before where they select the date.

    The survey is preloaded on Tablets and am using Power Automate to extract the data to another database and add them to an event tracker so can't have multiple forms (I don't think).

    I'll keep trying to find a way this can work

  • Verified answer
    thebruuu Profile Picture
    thebruuu 422 on at
    RE: Update Customer Voice Survey Question choices from dataverse tables

    Hello

    In short ... no.

    Dataverse Tables are not the operational tables of Customer Voice; Dataverse tables are only a copy of operational table .. .and data goes only in one way, from operational tables to dataverse tables. So not possible writing to questions operational tables

    Only chance is IF the choices are not totally free but are grouped in use cases, that can be hard coded

    and you would navigate through a use case, using conditional branching.

    And that this is your only chance, as choices cannot be based on variables

    IF choices  are grouped in use cases, You could then achieve your goal with variables in survey links + branching based on variables.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans