Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
HI
I am trying to create a web links in a custom column, i need to info from another column in the table to complete the url
the column name is (Do Not Modify) Item and the table name is Item Reg
the link in the column looks like this, but doesnt work, anyone any idea what i'm doing wrong here ?
"https://myorg.crm4.dynamics.com/main.aspx?etc=145&id={”&Item Reg[(Do Not Modify) Item]””}&pagetype
Solved! Go to Solution.
this works 🙂
"https://myorg.crm4.dynamics.com/main.aspx?etc=145&id="&[#"(Do Not Modify) Item"]&"&pagetype=entityrecord")
Well, I think you have an extraneous " right before your }.
Are you getting an error or?
Nope no errors i did remove the extra " but it didnt help the URL looks like this in the report https://myorg.crm4.dynamics.com/main.aspx?etc=145&id={”&Item Reg[(Do Not Modify) Item]””}&pagetype=entityrecord so it doesnt take the value from the column i am refering to Item Reg[(Do Not Modify) Item] the value should be a number
e.g. https://myorg.crm4.dynamics.com/main.aspx?etc=145&id=1234567891545&pagetype=entityrecord
this works 🙂
"https://myorg.crm4.dynamics.com/main.aspx?etc=145&id="&[#"(Do Not Modify) Item"]&"&pagetype=entityrecord")
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 40 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 26 |