cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

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

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)

 

Bunly11_0-1610603632843.png

Thank you

 

3 REPLIES 3
Helper II
Helper II

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.

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?

Microsoft
Microsoft

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.

v-xiaochen-msft_0-1610957810482.png

 

 

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:

LLL.gif 

 

Best Regards,

Wearsky

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

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,915)