-
Survey Sender User cannot be retrieved from Survey Invitation Table
When we send a survey by clicking on Send Survey button on a Contact, we need to analyze the responses based on the user who has initiated the survey sending (The user who has clicked on the button), but unfortunately we could not find any information who was the survey sender.
Note: A Survey invitation is created by Standard Microsoft Flow and "Send a survey" Action. But since the flow is run on the context of the admin user, therefore the "Created by" field on Survey invite record is the admin user and not the initiating user. We noticed that survey sender is kept as Ownerid of "msfp_customervoiceprocessor" record, but unfortunately it is not passed to Survey Invitation! If that already available information on "msfp_customervoiceprocessor" could have been sent to "Survey Invitation" table by Microsoft that would make it possible to make the report that we need and maybe many other organizations using Customer Voice would need the same as well. As an example to make a report on Customer Satisfaction metric related to each agent.