Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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")
| User | Count |
|---|---|
| 55 | |
| 42 | |
| 28 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 74 | |
| 60 | |
| 40 | |
| 22 | |
| 22 |