Invalid Formula. Expected a value compatible with 'DataSource'.

(1) Share

Report

Posted on by Evan_S1

341

-my data source connected to the app is a table in Excel named "Production"

-On Screen 1 I have vertical gallery named Gallery1.

-In that gallery there is a next arrow by each record, When the arrow next to the record is selected it navigates to Screen 2 (Update Production Board) which displays the record in an Edit Form

-My next arrow onselect function is:

Set(VarFormMode,FormMode.Edit);Navigate('Update Production Board');Set(VarItem,ThisItem)

-Form datasource function is 'Production'

-Form defaultMode is VarFormEdit

-Form Item is VarItem

VarItem shows squiggly red line as if there is an error. Not sure what the issue is because I have an identical screen and different excel table that is set up exactly the same and the error does not show on that one

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

venturemavenwill 1,198 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

What is the DataSource of your Edit Form?

If you created the app from a blank canvas, then you would need to manually define both the Item and the Datasource parameter of your Edit form. If the form was copied from another page in your app, it probably has another datasource that is not compatible.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (1)

Report
Copy link

Link copied!

@venturemavenwil Below is what is in the DataSource and Item Fields of the EditForm.

The DataSource "Production" is the correct data source I am trying to pull from

Was this reply helpful? Yes No
venturemavenwill 1,198 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Does your Excel table have an unique ID column?
If so, can you try something like Set(VarItemID, ThisItem.ID)

and in your Edit Form, use

Lookup(Production, ID = VarItemID)

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (1)

Report
Copy link

Link copied!

It does not appear that my Excel table has any Unique ID's. The only thing on them is dropdown created from data validation.

What function slection would I put the "Lookup(Production, ID = VarItemID)" that you mentioned?

Was this reply helpful? Yes No
Verified answer

venturemavenwill 1,198 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

In your case, I would try to use two variables:
On your next button in your gallery, you can use Set(SalesOrder, ThisItem.'Sales Ord');Set(SalesItem, ThisItem.Item)

and in your edit form, in the Item parameter, use both variables in the lookup
LookUp(Production, 'Sales Ord' = SalesOrder && Item = SalesItem)

Based on the example above, Sales Order + Item should be unique.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (1)

Report
Copy link

Link copied!

You are on to something! Although it only fills in the sales order and Item. How do I add the rest of the columns in the excel table so it autofills all of them and can make updates after

Was this reply helpful? Yes No
venturemavenwill 1,198 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Just to make sure I understand - when you click on add fields in the edit form now, it only shows the two columns sales order and Item, and none of the other fields show up?

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (1)

Report
Copy link

Link copied!

Disregard that, I did something wrong on my end. Everything work great! thank you!

Was this reply helpful? Yes No