Power Platform Community Forum Thread Details

Hi,

I'm trying to load a ListBox from data I get from an SQL server procedure.

I've tried:

Having the procedure call to my screen OnVisible function and store it to a local variable, and set the list Items to this variable:
Screen OnVisible:
UpdateContext({_comment: "",_datePicked:_dateSelected,
_passengers: getRidesOfDay.Run(_datePicked, carComboBox.Selected.Value)
});
ListBox Items=[_passengers]
Set the ListBox Items property directly with the procedure:
getRidesOfDay.Run(_datePicked, carComboBox.Selected.Value)

I'm getting the error: "Behavior function is a non-behavior property. you can't use this property to change values elsewhere in the app"

Is there a way to fill the ListBox from the stored procedure?

If my procedure returns a list of entries with two values for each item, should I treat this differently?
(I've tried to search for it without success in this forum and other places)

Categories:

Building Power Apps