Select next record from a ComboBox

[Anonymous]

Hi guys

Soo i have this combobox wich i load my data (ID), filter by "Gallery5.Selected.ID", but i have two records associated with the selected ID, by default i have one of the records alredy selected, soo far soo good, my goal is to click a button and select the next record existing on my combobox without switch it manually.

Any thougths? ( Forgive me for a not perfect english, not a ative speaker)

Many thanks,

Pedro

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about the formula you typed within the Items property of the ComboBox control?

Could you please share more details about the DefaultSelectedItems property of your ComboBox control?

Further, do you want to select the next match record on your ComboBox when you click the Button?

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

The data structure of my data source as below:

My App's configuration as below:

Set the OnStart property of the App control to following:

ClearCollect(CoursesCollection, '20181019_case9_Courses');
Set(Index, 1)

On your side, you should add the following formula within the OnStart property of the App control or OnVisible property of the first screen of your app:

Set(Index, 1)             /* <-- Initialize the Index variable */

Set the Items property of the Gallery  (Gallery1) to following:

'20181019_case9_OutComes'      /* <-- Here type your own data source to populate your Gallery */

Set the OnSelect property of the Gallery to following:

Set(Index, 1)

Set the Items property of the ComboBox to following:

Filter(CoursesCollection, Outcome.Value = Gallery1.Selected.Title)   /* <-- Filter reocrds based on selected item in Gallery1 */

On your side, you should type:

Filter('YourDataSource', FilteredColumn = Gallery5.Selected.ID)  /* <-- Filter records based on selected item in your Gallery. The FilteredColumn represents the column you want to compare with the ID column value of the Gallery selected item*/

Set the DefaultSelectedItems property of the ComboBox to following:

Last(
     FirstN(Filter(CoursesCollection, Outcome.Value=Gallery1.Selected.Title), Index)
)

On your side, you should type:

Last(
     FirstN(Filter('YourDataSource', FilteredColumn = Gallery5.Selected.ID), Index)
)

Set the OnSelect property of the "Next" button to following:

Set(Index, Index+1)

Please check the following GIF screenshot for more details:

Best regards,

[Anonymous]

---

Hi there friend,

Many thanks for the reply to my problem, i can tell you that was exacly what i was looking for, and your code indeed solved my issues, my program is now working was i wished in the first place 

Many thanks,

Pedro