Hello, I am facing a strange issue with href links within the body of emails that are generated through a power app visual within my power bi report.
The Power BI report itself is fairly simple, it has a landing page, a page for KRI-type information, and a page that has a power app visual that allows users to create/maintain items in the dataset. When a user submits a new item, power apps sends an email to the user acknowledging receipt of said entry. Within the email is a link that is set up to open the power bi report, navigate to the power app visual page, and preload ViewForm with the proper ID.
Here is the code I use to generate the email:
Set(varAppLink,
"https://app.powerbi.com/mypowerbireport?experience=power-bi&filter=Personalization/ReportPage eq 'scrViewEntry' and Report_Data/Entry_ID eq '" & varNewEntryID & "'");
Set(varEmailContents,
"A new entry has been submitted through the Power BI Intake application and is awaiting an approval decision. " &
"Please click on the <a href='" & varAppLink & "'> LINK </a> to open the Intake Application." & "<br><br>" & "<table border=1>" &
"<tr><td>Intake ID</td><td>" & varNewEntryID & "</td></tr>" &
"</td></tr></table>" & "<br><br>" &
"This email and its attachments are confidential. Any unauthorized use or disclosure is prohibited. If you receive this email in error, please notify " & "me by reply email and permanently delete the original without making any copies or disclosing its contents.");
Set(varEmailTo, "me");
Set(varEmailSubject, "New Intake Submitted");
Office365Outlook.SendEmailV2(varEmailTo, varEmailSubject, varEmailContents);
This code generates the email just fine, however, when you click the link within the email, it launches the power bi report and does not pass the parameters. Hovering over the link hyperlink within the email, I can see the following url:
"https://app.powerbi.com/mypowerbireport?experience=power-bi&filter=Personalization%2FReportPage%20eq"
Somehow, some component in the email creation or delivery is truncating the url link at the first instance of ' within the string. I can manually type in the correct url address bar to get the report to open to ViewEntry page and have it display the correct entry information, so I know the report is set up to correctly pass the parameters through to the power app visual. My issue is that somehow, somewhere along the line the syntax for the report parameters are being stripped off the url.
Does anyone know how I can get around this?
