Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

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

Posted on 2 Jan 2022 10:26:46 by 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

 

  • CraigPezet Profile Picture
    CraigPezet 44 on 08 Nov 2022 at 14:05:34
    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 don't know if it helps but I had the same issue when applying the dataverse view to a gallery the images with the "ThisItem.Image" image property would not display. I believe this is because in applying a view to the dataverse the view itself cannot display image columns in the view.

     

    Using the below formula in the Imange field resolved the issue as it then looks up the image from the datasource rather than the view to display it in the gallery.

     

    LookUp(Datasource,NameColumn=ThisItem.NameColumn,ImageColumn.Full)

     

    Kind regards,

    Craig

  • Ram Prakash Profile Picture
    Ram Prakash 5,065 on 23 Jan 2022 at 16:32:08
    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 🙂

     

     

  • calerof Profile Picture
    calerof 255 on 23 Jan 2022 at 14:40:32
    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

  • Ram Prakash Profile Picture
    Ram Prakash 5,065 on 03 Jan 2022 at 10:02:49
    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

     

  • calerof Profile Picture
    calerof 255 on 03 Jan 2022 at 09:46:53
    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:

    error5.png

    Thanks!

    Fernando

  • calerof Profile Picture
    calerof 255 on 03 Jan 2022 at 09:41:49
    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:

    error3.png

    And yes, if I remove the View the error goes away and the Gallery works just fine in my case:

    error4.png

    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

     

  • Ram Prakash Profile Picture
    Ram Prakash 5,065 on 03 Jan 2022 at 09:41:22
    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

  • Bipin D365 Profile Picture
    Bipin D365 971 on 03 Jan 2022 at 09:29:42
    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/

  • calerof Profile Picture
    calerof 255 on 03 Jan 2022 at 09:22:49
    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:

    error1.png

     

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

    error2.png

     

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

    Thanks,

    Fernando

  • Bipin D365 Profile Picture
    Bipin D365 971 on 03 Jan 2022 at 09:01:39
    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 -

    bipinshan_0-1641200418704.png

     

    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/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard

Featured topics