Invalid Formula. Expected a value compatible with 'DataSource'

Like (6) Share

Report

Posted on 10 Jun 2020 07:54:38 by Community Power Pla...

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?

Categories:

Connecting to Data

All responses (21)

Answers (1)

Verified answer

v-siky-msft on 11 Jun 2020 at 05:36:12

Like (35)

Report
Re: Invalid Formula. Expected a value compatible with 'DataSource'

Hi @Anonymous ,

Please try with this alternative workaround.

Set OnSelect of BrowseGallery1:

Set(SelectedItemID, ThisItem.ID)

Set Form1.Item property:

LookUp('Opportunities and Risk',ID=SelectedItemID)

Use lookup function to retrieve the record from data source, and I believe this will resolve the error.

Hope this helps.

Sik