Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Boz1
Regular Visitor

User Experience Survey: Power BI/Power Automate/Microsoft Forms

Greetings,  

 

We want to send an IT ticketing survey to targeted individuals to rate their experience. Our current idea is to use a Power BI report to identify the user’s email address and ticket number. Then use Power Automate to send an email to the target user with a link a Microsoft Form. If possible, we would like to take the ticket number from the Power BI report and pre-fill a text field on the Form.  

 

I am not sure this is a viable solution. Looking for insight from the form if this is too lofty of an ask.  

 

Thank you, 

5 REPLIES 5
christinepayton
Super User
Super User

Okay this is hilarious, I stand corrected - they juuuust added this feature a couple weeks ago! Good timing. 🙂 

https://techcommunity.microsoft.com/t5/microsoft-forms-blog/pre-fill-responses-in-your-microsoft-for...

Thanks for the response. I looked at this also but unfortunately the prefilled information is not dynamic for each individual survey sent out. So, in my use case the ticket number would need to change for each recipient.

christinepayton
Super User
Super User

You would need to use canvas Power Apps for this instead of MS Forms for the survey. What you need to be able to do is to put the ticket ID into the URL that you send the user, and then have the app capture that when it creates the survey record by pulling it from the URL parameters. Canvas apps can handle URL paramaters like this, MS Forms can't unfortunately. I wish it could. 🙃

lbendlin
Super User
Super User

What's the value add of Power BI in this process?

Thanks for responding. The purpose of the Power BI report is to pull in the ticket number and the email address of the person that needs to be contacted. 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.