Invalid formula. Expected a value compatible with 'DataSource'

[lewis1682]

Hi all,

I am trying to create a edit form, the items for the form are selected from the gallery.

I have the following currently:

List = ep_users

gallery = gallery_edit

form = form_edit_user

Within the gallery_edit.items I have the following code:

SortByColumns(
  Filter(
    AddColumns(     
      ep_users,
      "PersonsName",
      user_info.DisplayName   
    ),
    StartsWith(user_info.DisplayName, txt_search_edit_screen.Text) Or EndsWith(user_info.DisplayName, txt_search_edit_screen.Text) Or StartsWith(user_info.Email, txt_search_edit_screen.Text)
  ),
  "PersonsName",
  Descending
)

Within the form_edit_user.DataSource I have:

ep_users

Within the form_edit_user.item I have:

gallery_edit.Selected

I am getting the following error under form_edit_user.item 

Invalid formula. Expected a value compatible with 'DataSource'

Any help on this will be greatly appreciated.

Thanks 🙂

[samuelJ]

The item() property of a form I believe needs to relate back to the datasource in its DataSource() property.  You should retreive one item from the datasource to populate the form.  So something like the below example:

First(Filter(myDatasource, valueInDB = selectList.Selected.value))

You need to relate some (probably a distinct) value back to a record.  

[lewis1682 · Accepted solution]

I have managed to find a solution, for the select icon for each item in the gallery, for OnSelect instead of it being Select(parent) (or whatever it defaults to) I have created a variable which is updated whe the icon is pressed to capture the ID, the item field for the form is then set to this variable.