Unanswered

Displaying an image of type file in Portal page

(0) Share

Report

Posted on by GWham1

Hi all,

I have created a new field called 'gw_image' of type 'file -> image' and set the option 'can store full image' to be true.

I wondered if there was a way to display this using FetchXML? Everything I have tried has not worked.

<fetch>
 <entity name="gw_onlineresources">
 <attribute name="gw_onlineresourcesid" />
 <attribute name="gw_image" />
 <order attribute="gw_name" descending="false" />
 </entity>
</fetch>

{% for result in onlineresources.results.entities %}
 {{ result.gw_image }}
 {{ result.gw_image.Type }}
 {{ result.gw_image.Size }}
 {{ result.gw_image.Url }}
 {{ result.gw_image.Value }}
{% endfor %}

If the FetchXML method is not an option, I could maybe use the Image URL. From my little attempts thus far, I cannot seem to get it to display the full image (only a tiny thumbnail version) - despite setting full=true

/Image/download.aspx?Entity=xxx&Attribute=xxx&Id=xxx&Full=true

https://learn.microsoft.com/en-us/power-pages/configure/image-column

Any help much appreciated!

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (1)

h4x0rz3d 8 on at

Like (0)

Report

@OliverRodriguesany ideas?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report
Hi, this worked fine for me:

Can you share the full code as I think you shared snippets from different places, this is my code working fine:

{% fetchxml accounts %} <fetch> <entity name="account"> <attribute name="accountid" /> <attribute name="ollie_accountimage" /> </entity> </fetch> {% endfetchxml %} {% for result in accounts.results.entities %} Account ID: {{ result.accountid }} Image Column Type: {{ result.ollie_accountimage.Type }} Image Size: {{ result.ollie_accountimage.Size }} Image URL: {{ result.ollie_accountimage.Url }} Image Base64: {{ result.ollie_accountimage.Value }} ========================================================== {% endfor %}

Was this reply helpful? Yes No
GWham1 on at

Like (0)

Report
@OliverRodrigues That's a little strange.

I just can't seem to get any results for gw_image at all. I wondered if it was due to it being a custom table? 🙄

Did you create your column as the same type as the below?

{% fetchxml onlineresourcesquery %} <fetch> <entity name="gw_onlineresources"> <attribute name="gw_onlineresourcesid" /> <attribute name="gw_name" /> <attribute name="gw_image" /> <attribute name="gw_imageid" /> </entity> </fetch> {% endfetchxml %} {% for result in onlineresourcesquery.results.entities %} Online Resource ID: {{ result.gw_onlineresourcesid }} Online Resource Name: {{ result.gw_name }} Online Resource Image ID: {{ result.gw_imageid }} Image Column Type: {{ result.gw_image.Type }} Image Size: {{ result.gw_image.Size }} Image URL: {{ result.gw_image.Url }} Image Base64: {{ result.gw_image.Value }} ========================================================== {% endfor %}

Was this reply helpful? Yes No
GWham1 on at

Like (0)

Report

@OliverRodriguesOne last thing i can think of is the enhanced data model. Are you using that?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

I am using the enhanced data model, but in this particular scenario I am not using the record Picture, I am using a custom attribute with the Type = Image, I thought this was what you were doing as well

I have used the record picture within the Contact, I can try in a custom table if the above scenario doesn't suit you

When creating the new column, select Image as Data Type:

Was this reply helpful? Yes No
GWham1 on at

Like (0)

Report

@OliverRodrigues That's the same as I have done. I also created a field on an out the box table for 'account' and the same problem existed for me. I noticed If you create a column as data type 'Image' it changes it to become 'Single line of text' when previewing/editing the column (for some reason), but displays as an 'image' in the column table. I'm assuming you get the same behaviour?

I also created another column called 'gw_resourceimage' as noticed mine was set as default picture (which I did not select upon creation), but still having the same issue.

I am on portal version 9.6.1.26 are you on the same?

Was this reply helpful? Yes No
dalemb 42 on at

Like (1)

Report

Hi @GWham1 ,

I faced the same issue as you 2 weeks ago, raised a Microsoft ticket and they have no solution for this. The enhanced data model has issues, that's for sure. And the online help is confusing or not helping.

I found a way to solve that, you need to adapt the following code:

<img src="https://AA-AAAAA.powerappsportals.com/Image/download.aspx?Entity=bsda_standardconfig&Attribute=bsda_imagepresentation1&Id={{listItem_z2.bsda_associatedstandardconfigidfortheimages}}&full=true" />

AA-AAAAA
Replace that with your portal URL

bsda_standardconfig
Replace that with your table logic name

bsda_imagepresentation1
replace that with your image column of that table (file type image)

Now, the important part:
{{listItem_z2.bsda_associatedstandardconfigidfortheimages}}

That's the fetch result, unique guid for that specific row (where the image is located)
Replace with your fetch.

Cheers,

Was this reply helpful? Yes No
GWham1 on at

Like (0)

Report

@DaleThanks, I was trying to avoid using the Image URL but seems like this is the only method for the time being. That works fine, as you suggested. Strange how @OliverRodrigues got the above working. There must be some issues somewhere along the road - maybe he is running a different version?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

"I noticed If you create a column as data type 'Image' it changes it to become 'Single line of text' when previewing/editing the column (for some reason), but displays as an 'image' in the column table. I'm assuming you get the same behaviour?"

Yes I am getting the same behaviour, it seems to be a wider bug on the Power Platform.

My Portal version is Portals 9.6.2.6

not sure if it's related to that

Was this reply helpful? Yes No
GWham1 on at

Like (0)

Report

@OliverRodriguesI'm assuming you're on early upgrade? I could try that to rule it out. I'm assuming, I just need to wait around until that updates? Is there a quicker way to force it to update?

Was this reply helpful? Yes No