Image URL not displaying in visual

[Unicorn_Tech]

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(ISBLANK(new_packinghouseevaluations[cr7f8_photospacking1_url])),

        CONCATENATE("https://grapacrm.crm4.dynamics.com/", new_packinghouseevaluations[cr7f8_photospacking1_url]),

        BLANK()

    )

The column when formatted as an image url is broken in the visual.

If I format the column as a web url, a clickable web url appears in the visual, which when clicked, opens the photo.

So I can't figure out why the image url isn't working.

Any ideas?

[Unicorn_Tech]

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=...

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]

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]),

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

    )

[Unicorn_Tech]

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

[PijushRoy]

Hi @Unicorn_Tech 

Are you using image url in Table visual or any other visual? 
Is your URL link end with .png or .jpg like this extension