I have a Gallery on the left side of the screen, and an Edit form on the right side of the screen. Both of them are connected to the same SharePoint list. Default for the list items to show up in the Edit form, with no errors:
- Items: 'Test SharePoint List'
The initial problem in the SharePoint list is that it has a lot of extra line items that I do not want to be displayed in the Gallery, so I've applied some rules:
- Items: Sort(Distinct(Filter('Test SharePoint List', Workstream = "Test"), 'Workflow Name'),Value,SortOrder.Ascending)
As soon as I apply the sort, distinct, and filter on the list... I get the following error:
- Invalid Formula. Expected a value compatible with 'DataSource'

Has anyone ran into this error? Seems like I am unable to 'manipulate' the data in the Gallery or it messes up the Form.