
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!
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.