Go to Another Screen Based on Value

[tduncan1]

So I have an assignement screen that only shows the ID, but I want the user to be able to click on the ID and take  the user to the Equipment Detail Screen based on the value.   Can this be done?

[RusselThomas]

Hi tduncan1,

Yes, I believe so - with a few assumptions.

Assuming this is a viewform that has had it's Item set from a Gallery somewhere (let's call it Gallery1) and assuming you just want the next screen to be another viewform but on some other set of data related to the "Equipment ID" of this item (which I'm assuming to be a separate source of equipment data and also for the actual column name to be something like Equipment_x0020_ID) then...;

Select the Id field/label/datacardvalue thing on this screen and set the following;

DisplayMode: DisplayMode.Edit

OnSelect: Navigate(newScreen, Transition.None)

On newScreen, insert a new viewform, set

DataSource: your equipment data source (let's call it equipmentSource)

Item: LookUp(equipmentSource, EID=Gallery1.Selected.Equipment_x0020_ID)

If you're not getting your initial viewform from a Gallery selection, try passing the ID as a variable between screens instead, so;

AssignmentList ID label:

 DisplayMode: DisplayMode.Edit

OnSelect: Navigate(newScreen, Transition.None, {varID: ThisItem.Equipment_x0020})

EquipmentList ViewForm:

DataSource: your equipment data source (let's call it equipmentSource)

Item: LookUp(equipmentSource, EID=varID)

Hope this helps,

RT

[tduncan1]

I'm A little confused, but hopefully I can explain it a little more.

The Assignment Screen is a Detail Screen (generated from my Sharepoint List) and I want the user to be able to click on the Equipment ID Value and go to the Equipment Detail Screen (generated from my Sharepoint List).

[tduncan1]

I'm guessing I will have to create a whole new form instead using the existing detail form?

[RusselThomas]

Hi tduncan1,

So the link between the two sets of data is the equipment ID - called "Equipment ID" on your Assignments list and "EID" on your Equipment list. 

"Equipment ID" has a space in the name, so there's a good chance the column in the list also has a space and this is usually translated into _0x0020_ by PowerApps.

Give the formulas I posted a try and see how it goes 🙂

I would create a new screen with a new form to start with - once you get the hang of the formula syntax you can just have one form....or keep both if it's easier for you, the overhead on PowerApps is minimal.

Kind regards,

RT

[tduncan1]

Thank you.

My Issue was trying to build some a condition instead of building a whole new screen.