Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Warn if using RemoveIf in a Gallery with a connection that is not the same as the Gallery Data source #846

Open
daryllabar opened this issue Nov 16, 2022 · 0 comments

Comments

@daryllabar
Copy link

This bit me pretty hard today:

I have a gallery that is displaying values from a SQL View

This is the data source:

SortByColumns(Filter('[dbo].[SiteHistoryView]', SiteNumber = SelectedDispatch.SiteNumber), "CreatedDate", Descending)

I've added a delete Icon with this OnSelect() to delete the record form the source:

RemoveIf('SiteHistory', HistoryID = ThisItem.HistoryID);

Here is the results of me clicking the delete icon starting from the bottom:
image

This is due to only the top one or two records in the Gallery having an id that is in the top 500 of the SiteHistory, and since it is not delegatable, only the rows in the view that correspond to the top 500 rows in the table are deletable. Doing a RemoveIf in a Gallery that uses a different source than the Gallery will often not do what the user want/expects and a warning should probably be created about delgation .

Session Details:

Timestamp: 2022-11-16T14:58:17.761Z
Session ID: 36f09a10-6520-11ed-82ff-7ba4fba895c0
Tenant ID: d843cb99-8386-4d4c-a924-e7147b4e184a
Object ID: dc40ed33-a73f-4ffe-9c10-bf35b3cd21e8
Build name: 0.0.20221101.1-2210.5-prod
Organization ID: c71b1ef6-d833-48ce-b6aa-423bcdcab3b8
Unique name: orge3a8686f
Instance url: https://orgfa3b91e3.crm.dynamics.com/
Environment ID: Default-d843cb99-8386-4d4c-a924-e7147b4e184a
Cluster environment: Prod
Cluster category: Prod
Cluster geo name: US
Cluster URI suffix: us-il105.gateway.prod.island

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant