web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Selecting an item in a...
Power Apps
Answered

Selecting an item in a gallery, then fill it in a form based on the information

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello there!

I am having an application where I have multiple tickets and can select one. Screen is named SubOrderScherm. The data source is named "ProjectLijsten"
OpleverApp - Opgeslagen (niet gepubliceerd) - Power Apps - Google Chrome (gyazo.com)

I then want to take the Ordernumber, which can be gotten by using; 
Gallery2.Selected.Order

But we also need to get the subordernumber, which is also a unique number
We can get it with this; Gallery2.Selected.Subordernummer

Now we need to combine those, I guess using this;

Gallery2.Selected.Order & "-" & Gallery2.Selected.Subordernummer

Result example: 20009-12

So I have a form on another screen, whenever you select a ticket, as explained above, you will be navigated to another screen named "DetailScherm", the form is on this screen. 

We have a datasource named [@'D-Nummers-OpleverApp'] for the form

We need to get the selected item using the formula; Gallery2.Selected.Order & "-" & Gallery2.Selected.Subordernummer

We then need to have the "Item" of the form to filter on the source [@'D-Nummers-OpleverApp'] where Gallery2.Selected.Order & "-" & Gallery2.Selected.Subordernummer is equal to 2 colomns in that datasource, these are named "Order" & "-" & "Fase", This is equal to the result example: 20009-12 I was talking about before.

Sorry for the bad explanation, if I need to explain it better, let me know!

Thanks in advance for your help!

Categories:
I have the same question (0)
  • Verified answer
    eka24 Profile Picture
    20,923 on at

    I rather suggest you dont join the columns unless there is some reasons to do that.

    Kindly follow:

    1. Since they are on different screens, Set a variable when you click on the Gallery.

        So if you have an icon/ button inside the Gallery (You can hide it),
      OnSelect: Set(SelectedItem,ThisItem)

     

    2, On the Item property of the Form:

       LookUp([@'D-Nummers-OpleverApp'],Order=SelectedItem.Order && Fase=SelectedItem.Subordernummer)

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard