Good afternoon. We using Power BI and MS CRM data and creating a URL that we link to an account to new call entity to allow our team to click the hyperlink and create a "New Phone Call" with fields populated such as their phone number, description, direction and regarding.
Everything works good with the compound hyperlink, except if the account name has a "&" in it. I have tried to encapsulate this multiple ways, including & single quotes etc. but have not found a way to correctly create the link using the data. I have to include the ID, name and entity from my understanding, it can not just be the ID and entity (I wish it could!)
Microsoft Dynamics 365
2019 release wave 2 enabled
Below is an example of a working URL and a non working URL.
Non Working Account (has "&" in the name):
COMPANY.crm.dynamics.com/main.aspxCS%20&%20S%TEST%20SYSTEMS%20INC%26regardingobjectidtype%3Daccounts%26%26subject%3DRenew%20Outcall%26phonenumber=5555555555%26description=Account%20Number:%20%2010000002%0AAccount%20Name:%20CS%20&%20S%TEST%20SYSTEMS%20INC%0AContact%20Name:%20Mike%20Smith%0AContact%20Number:%5555555555
Any suggestions?