While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

(1) Share

Report

Posted on by calerof

255

Hi,

I have a Dataverse table with a View to filter data. The table includes images. When I try to use the View in a Gallery with images I get this error:

The requested operation is invalid.
Server Response: Problem Reports failed: Distinct is not allowed when image attributes are selected.

Does anyone know what it is?

Thanks for any help.

Regards,

Fernando

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Ram Prakash 5,576 Super User 2025 Season 2 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hello @calerof,

Hope you have verical gallery with Image, if yes then you can simply use ThisItem.IMAGEFIELDNAME

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hi @calerof ,

I have a gallery control with Item property selected as View as shown below -

And Image control is visible as expected.
Image control Item property -> Thisitem.Image

What is your item property formula and also please send your view filter criteria.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
calerof 255 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hi all,
I'm using the image field name, of course:

The error occurs when using any View, also with the default active View:

Only note here is that I'm working with a Developer account.
Thanks,
Fernando

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hi @calerof ,

Does it work when you unselect view from your Gallery item property?

Could you please send the gallery item peroperty formula?

I'm also using Power Apps Community Developer plan and it works on my canvas app.

Please mark my answer verified if this is helpful!
Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/

Was this reply helpful? Yes No
Ram Prakash 5,576 Super User 2025 Season 2 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hello @calerof,

Can you please show me the Image Field from Table.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
calerof 255 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hi @bipinshan ,
Here's the Items formula:
And yes, if I remove the View the error goes away and the Gallery works just fine in my case:
I just saw yesterday this post:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/BUG-Can-t-use-a-view-of-a-table-that-contains-image-fields-in/idi-p/1333917
Thanks for your help!
Fernando

Was this reply helpful? Yes No
calerof 255 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hi @rampprakash ,
Here is the table:
Thanks!
Fernando

Was this reply helpful? Yes No
Ram Prakash 5,576 Super User 2025 Season 2 on at

Like (0)

Report
Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hello @calerof,

For Filtering based on Text Column, You can try below Filter Query

Filter('Problem Reports';DATAVERSECOLUMNNAME=TextField_1.Text))

Remove the View Filter from the Items.

If you want to made multiple filter then you can try below code

Filter('Problem Reports';And(DATAVERSECOLUMNNAME=TextField_1.Text,DataVerseColumnName = 'test')))

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
calerof 255 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

I appreciate your response. But this may work but is a work around, right? The process I'm following is correct and should work with a View. I think this is a bug.
I don't know what to do with this post, if close it accepting your solution will not solve the root cause.
Regards,
Fernando

Was this reply helpful? Yes No
Ram Prakash 5,576 Super User 2025 Season 2 on at

Like (0)

Report

Re: While selecting a view from Dataverse in a Gallery with images I get the error: Distinct is not allowed when image attributes are selected.

Hello @calerof,

Cool, If you find answers please input the same and Accept as a Solution 🙂

Was this reply helpful? Yes No