I am facing an error when I try to build an Edit Form based on my Gallery selection, based on the SharePoint List "Opportunities and Risk".
In my gallery, named "BrowseGallery1", I have the following script in the "Items" field:
Filter('Opportunities and Risk', 'Entry Type'.Value = Label2.Text)
I configured by Edit Form, labelled "Form 1" Datasource:
'Opportunities and Risk'
And the Item field:
However, I am getting error "Invalid Formula. Expected a value compatible with 'DataSource'". I believe I am already pointing the Form and Gallery to the same data source. What could be missing from my setup?
Solved! Go to Solution.
I think I might have discovered the source of this problem. I haven't tried the workaround yet but presume that it will work. I think it has to do with the nature of the datasource in the gallery that provides the selected value. If it's a simple datasource, say, a dataverse table, the Gallery.Selected value seems to work fine. If the datasource in the Gallery.Items attribute is something more sophisticated e.g. the output of a filter or search function, the Item attribute of the Display control seems to not be able to resolve the selection.
This was true of my scenario. Here's the datasource in the items attribute of my gallery on a "browse" screen
Filter( Search( AddColumns('Regulatory Business Processes', "blah", PlainText('Process Taxonomy Level 1')) ,TextInput1.Text ,"bipr_name" ,"blah" ) ,If(Radio1.SelectedText.Value = "All", !IsBlank(PlainText(Status)), PlainText(Status) = Radio1.SelectedText.Value) )
This data source works as desired in on the screen that displays the gallery. However, on my "details" screen, where I have the Display control, I get the error that others have experienced. When I comment out the datasource above and replace a simple reference to the underlying data source, the display control works fine.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for the next call on June 15, 2022 at 8am PDT.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.