Forum Discussion
Retrieve Power BI report name into sharepoint list
I have built a PowerBI dashboard feedback form using Microsoft Forms. I have connected the feedback form to a SharePoint list using Power Automate, so the customer feedback is saved in the SharePoint list.
The plan is to create a button on the powerBI dashboards for the customer to click on and fill out the MS form.
The only problem I have is that I need help to identify which report they are using when sending this form through. Can I generate the report name somewhere on the form to identify this?
Elijah94 Not with MS Forms. But I have done this with Power Apps forms, which can capture URL parameters in the form. So for example, what you would do is put your report ID in the URL for the Power App feedback form link as a parameter, and the parameter would set a hidden field in the form (you could call it "report ID") to capture the report ID. That lets you use one feedback form for any number of reports, just editing the URL for each report.
MS Forms will not take URL parameters to set fields, hence Power Apps. You have to be careful too with which version of the canvas app you create on the SP list - the ones you generate from SharePoint via the "customize the form" options will not work, you have to create the Power App from make.powerapps.com and just set your source to SharePoint (it's something about the SharePoint integration where it doesn't get the full feature set). This is notable only because I started with the former and had to restart with the latter when I did this. 🙂
