Linking a Form to row in a Data Table

(0) Share

Report

Posted on by akharns

433

Hello, friends.

I have a Form that I am trying to use to display additional data for the selected row in a Data Table. It was working at one time but now it is not. The form’s Item property is throwing the error “Invalid formula. Expected a value compatible with DataSource.” I can't see the problem. Maybe you can.

Here are some details:

Data Table: ‘Event List’

Data source-EventTable (in Excel)

Items=

AddColumns(

If ('Category selection'.Selected.Value="All",

Filter(EventTable,

Display<>"no",

'Submission Month'='Month selection'.Selected.Value),

Filter(EventTable,

Display<>"no",

'Submission Month'='Month selection'.Selected.Value,

Category='Category selection'.Selected.Value)),

"fmtDate", Text('Date/Time',ShortDateTime))

Form: Details

The Form displays three Data Cards for columns not shown in the Data Table
Data Source: EventTable (same as in Event List)
Item='Event List'.Selected
Error on Item: Invalid formula. Expected a value compatible with DataSource.
Note: The bottom label successfully displays 'Event List'.Selected.Filename (Filename is one of the data cards listed in Details).

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @akharns are you still experiencing this issue?

@Anonymous
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes. Nobody has replied yet and I have not found a solution. Thanks for following up. Any help will be appreciated.
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The AddColumns() is what is causing the issue. That creates a temporary collection of the data that is no longer lied directly to the actual data table. You could try removing the the AddColumns() and add a label to the gallery to display the formatted 'Date/Time'. However, if you must have the AddColumns() in the Items property then you need to add a Lookup() to the Item property of the form to get the selected record.

Example: Lookup(‘Event List’, 'Event List'.Selected.UniqueValueField = UniqueValueField)

*UniqueValueField would be the name of the field with the unique value for the record
akharns 433 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your reply.

I think you're saying that I should convert my data table to a gallery to give me flexibility to use a computed field for the date, or do a new query back to the EventList table to get the additional data elements. And I presume that the temporary table caused by the AddColumns is not accessible from my form.
Verified answer

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Sorry, I forgot that you were using a Data Table and not a Gallery. So you would need to change to a gallery to add a label and format it. The AddColumns is creates a temp table of records, so the DataTable.selected is pointed at a record on the temp table and not on your actual table and that is why you are getting the error.