cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Setting gallery default item

I'm new to powerapps and seem to be having trouble passing data between two forms.

 

I have the first form where the user can enter a Job number or use a button to list active jobs - this is on a new form.

 

The active jobs form has a gallery control that correctly lists the jobs available.

 

Where I'm stuck is getting the default property to jump to the job number from the first screen - I have passed it in via a variable (DefaultJobNo) - and this shows the correct value if I show it using a Notify message.

 

This is the items property on the gallery control

 

SortByColumns(Filter('[dbo].[ES_Job]',ActiveJob=true),"JobNo",Descending)

 

These are the things I've tried on the defaults property:

LookUp('[dbo].[ES_Job]', JobNo=Value(DefaultJobNo))

and

First(Filter('[dbo].[ES_Job]',JobNo=Value(DefaultJobNo)))

 

When selected I want to send the chosen job record back to the original screen.

 

Any clues or pointers on where I'm going wrong would be appreciated.

 

Thanks

 

Simon

 

2 REPLIES 2
Super User
Super User

Hello @SimonGoodman 

 

Without fully understanding your requirement, you should be able use a gallery.selected in the form property. If this doesn't answer your question, plesae add some print screens of the screens and formulas, or attach the app so that we can check it out.

 

Dawid van Heerden
Follow on Twitter: @davestechtips
Subscribe to YouTube: https://www.youtube.com/davestechtips?sub_confirmation=1
**If you found this reply helpful, please mark this as the answer to close the topic and make it easier to find for other people with similar questions.

Community Support
Community Support

Hi @SimonGoodman 

 

Could you please share more details of your App screens and controls?

Is the original screen is Browse screen, and is the gallery in this screen?

 

Best Regards.

Yumia

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Solution Authors
Top Kudoed Authors
Users online (42,552)