Invalid Formula. Expected a value compatible with 'DataSource'

[Anonymous]

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:

BrowseGallery1.Selected

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?

[Anonymous]

Worked perfectly, thank you so much! 

[MJL1]

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.

[krishangopi]

But that's still a bug against the expected behavior of data source operations. It looks to me that PowerApps is becoming worse day by day.

[mrdickiePA]

Yes I can concur with Muli but I am still unable to find the answer. The workaround did work for me (once i got the right syntax and spelling right! Actually I was too quick to answer there. I do get some data pop up when I click on the item in browser gallery but details screen only picks up the first line in my datasource so its like its not filtering or something. I'm using a search function to narrow down my items incidentally

[jvdduke]

This also happens when the Browse Gallery is a flexible height gallery. Even with the Data Source is a straight Sharepoint Table (no Filtering or Sorting). Microsoft please fix. The workaround works. FYI the variable in the workaround is not necessary. Can just use ID=BrowseGallery1.Selected.ID

[Fuzzy1]

I had to make minor changes for this to work for me. 

Set OnSelect of Gallery1:
Navigate(Edit_Screen,ScreenTransition.Cover); Set(SelectedItemId, ThisItem.Id)

Set Form1.Item property:
LookUp(Holiday_List,Id=SelectedItemId)

[Fuzzy1]

I had to make a minor change for this to work for me.  

Set OnSelect of Gallery1:
Navigate(Edit_Screen,ScreenTransition.Cover); Set(SelectedItemId, ThisItem.Id)

Set Form1.Item property:
LookUp(Holiday_List,Id=SelectedItemId)

[ccondran08]

Click on both the EditForm and then then  DetailForm which should be the boundary of the screen then go to the Advanced edit tab on the right and then look for the  Item field which should be under the "Data" heading. This item should say something like "BrowseGallery1.Selected". Check that this name matches your Browse Gallery name under the Summary screen. Double click on this and change to the correct Browse Gallery name then this error will go away.

[ccondran08]

Click on both the EditForm and then then  DetailForm which should be the boundary of the screen then go to the Advanced edit tab on the right and then look for the  Item field which should be under the "Data" heading. This item should say something like "BrowseGallery1.Selected". Check that this name matches your Browse Gallery name under the Summary screen. Double click on this and change to the correct Browse Gallery name then this error will go away.

[SCTdan]

This just happened to me.  SharePoint datasource, basic.  Weird thing is, it was working just fine, then I closed out of my browser session, and when I reloaded it today I started getting this error.  No changes.  I can go create a new app and it'll work exactly the same way I've got it set, but no matter what I do I can't get it working again in the original app, even deleting and recreating the connection and form etc.

Weird error, never seen it before.