Forum Discussion

Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
2 years ago

Image URL not displaying in visual

Hello.  I've searched the forum and not found a relevant answer. I have a dynamics field image, and I have a concatenated column like the following: Photopacking =     IF(         NOT(ISBL...
Need Help
Unicorn_Tech's avatar
Unicorn_Tech
Icon for Resolver I rankResolver I
2 years ago

Hi PijushRoy ,

This is the finished link, and when I open it it works for me, because I am signed in to my system iwth permissions. (as all users will be)

https://grapacrm.crm4.dynamics.com//Image/download.aspx?Entity=new_packinghouseevaluation&Attribute=cr7f8_photospacking1&Id=b671b810-77c2-4dbd-84e4-e5cfb7a1650f&Timestamp=638398767366464337

when clicked, it opens a browser with the image.

When i convert the column to image url, it shows a broken image icon.

 

I am using the table visual, and I also tried another visual specifically for images.

I also tried modifying the formula to this, removing an extra /

Photopacking =
    IF(
        NOT(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),
        CONCATENATE("https://grapacrm.crm4.dynamics.com", new_packinghouseevaluations[cr7f8_photospacking1_url]),
        BLANK()
    )
No change.
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Unicorn_Tech 

I have used this URL and ended with the .jpg or .png

https://i.ibb.co/SRcvhtf/2022-12-08-152256.jpg

 

 

Works perfectly. Please use the Image link in your measure and check

 

Photopacking =
    IF(
        NOT(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),
        CONCATENATE("https://grapacrm.crm4.dynamics.com", new_packinghouseevaluations[cr7f8_photospacking1_url]),
    )



  • Unicorn_Tech's avatar
    Unicorn_Tech
    Icon for Resolver I rankResolver I
    2 years ago

    Hi.  Thank you for the suggestion, I tried that formula, but unfortunately there has been no change.