How do I navigate to all the records for a selected record in a form?

[Bunly11]

Hi -

This drug record has three supplies. I am not sure what to put on the navigate button so I can view all three supplies

LookUp(SuppliesTBL, NewDrugID = SharePointIntegration.Selected.DrugID)

Thank you

[joeinmay]

On the navigate button or on the dropdown on change property send the matching items into a collection.

Next show the collection in a gallery next to the first gallery or a new screen.

[Bunly11]

Hi @joeinmay 

I am not sure how to get from the collection to show record 1 of 3.

I am able to show the selected record in a gallery or table.

Is it possible to show the selected records in the form (in this case 3 records) and use the arrow buttons to go back and forth?

[v-xiaochen-msft]

Hi @Bunly11 ,

Could you tell me:

Do you have 3 eligible records in your example ?

Do you have a display form control and some arrow controls?

Do you want to display the specific information of the three records separately by clicking the arrow controls?

If my assumptions are correct, I've made a test for your reference:

1\ This is my test list ‘LIST56’ . ‘NumberColumn’ is a number column.

2\ Add an arrow control in screen1 and set its onselect property to:

Set(Thevar,CountRows(Filter(LIST56,NumberColumn<6)));ClearCollect(Thevarcollection,Filter(LIST56,NumberColumn<6));Set(Thevar2,1);Navigate(Screen2)

// My formula filters 3 records based on my test list. Your data is different from mine, so the formula should be modified. This is an example.

3\ Add a display form control in screen2 and set its DataSource property to:

LIST56

Set the display form control’s Item property to:

Last(FirstN(Thevarcollection,Thevar2))

4\ Add an arrow control in screen2 and set its onselect property to:

If(Thevar2<Thevar,Set(Thevar2,Thevar2+1))

Set the arrow control’s Visible property to:

If(Thevar2=Thevar,false,true)

5\ Add an arrow control in screen2 and set its onselect property to:

If(Thevar2>1,Set(Thevar2,Thevar2-1))

Set the arrow control’s Visible property to:

If(Thevar2=1,false,true)

6\ Add an arrow control in screen2 and set its onselect property to:

Navigate(Screen1)

7\ The result is as follows:

 

Best Regards,

Wearsky

If my post helps, then please consider Accept it as the solution to help others. Thanks.