Power Platform Community Forum Thread Details

Hi there,

I have a Gallery which comes from Dataverse, and the Item's property includes AddColumn which is needed to evaluate three dates to find the earliest date, and sort the Gallery based on this date in ascending order. This sorts all fine. Code is:

Sort(AddColumns('Travel Requests',"EarliestDate", First(Sort(['Rail Date', 'Taxi Date', 'Accom Check-in date'],Value,Ascending)).Value),EarliestDate,Ascending)

In the Gallery, however, is an Edit button. Before I added the AddColumn and Sort elements above, OnSelect of this button is set to

Set(selectedTravItem, ThisItem)

and this worked originally.

Below the gallery on the same screen is a Form connected to the Dataverse table (Data Source property) and Item = "selectedTravItem".

Since adding the AddColumns to the Gallery, the Form displays an error in Item property of "Invalid formula. Expected a value compatible with 'DataSource'. Before I did this, the Edit button displayed the item in the Form for the user to edit, which I want to re-enable.

How can I fix this so that when the user selects Edit on that gallery item, they are presented with the information in the Form's data cards?

Thanks

Categories:

Building Power Apps