MDA - how to show one record according to selected previous record

(1) Share

Report

Posted on by agorkemt

Hello All,

I have a problem showing one record according to previous selected record. Let me explain it this way:

I have the shift tabel and there are 3 shifts, and operator table with 30 people recorded in it. each shift has 10 people working during the shift times.

When user selects 'shift 1' I want to show in the operator name column of the form of the table only the people working during shift 1 and when the user selects shift 3, they should see only people working during shift 3.

Anyone has a clue?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

agorkemt 73 on at

Like (0)

Report

Still looking for an answer! Anyone has a solution for this?

Thanks in advance

Was this reply helpful? Yes No
Verified answer

agorkemt 73 on at

Like (1)

Report

I do not know if this will work on the Model Driven Apps but using this formula in the Canvas app surely works!

first in the Items property of the first dropdown, write the shifts like ["Shift1", "Shift2", "Shift3"] than to the the Items property of the second dropdown where you want the condition work, write an "If" statement like;

If (

Dropdownshifts = shift1, ["name1", "name2"],

Dropdownshifts = shift2, ["name3", "name4"]

Was this reply helpful? Yes No