Share
Report
145I need help with this! Here is how my app works right now. I have 4 with the onchange for each combobox with the following code:
ClearCollect(Data,Filter(DataSource,Lookup = Label1.Text))
The value of the comboboxes are combined into a label (label1) and that is the lookup to filter my datasource which creates my collection. The collection is the used for my gallery.
I use the following code to create row numbers for each items in my gallery.
Patch(Data, Defaults(Data));
ForAll(
Data,
Collect(
tempCollection,
Last(
FirstN(
AddColumns(
DropColumns(
Data,
"RowNumber"
),
"RowNumber",
CountRows(tempCollection) + 1
),
CountRows(tempCollection) + 1
)
)
)
);
ClearCollect(
Data,
tempCollection
);
Clear(tempCollection)
This will create a new line and number everything 1 to whatever. I use this row number to do my patch. There is another combobox inside my gallery that uses the following code on change: Patch(Data, Lookup(Data, RowNumber = ThisItem.RowNumber), {Item: Combox2.Selected.No_})
Unfortunately, this patch looks like it works for a second then reverts back to what it was a second ago. What am I doing wrong?
All responses (
Answers (
