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
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
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
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
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:
Thanks for your help!
Fernando
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
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/
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
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/
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.