Power Platform Community Forum Thread Details

In advance, this is kind of hard to explain...

I am trying to figure out a way to make the a specific choice column define the output of another datacard. I currently have it hard coded like this:

If(
 DataCardValue4.Selected.Value = "1 OGV",
 "1 FW / 192 WG",
 "" Or DataCardValue4.Selected.Value = "27 FS",
 "1 FW / 192 WG",

This ends up being well over 150 lines (which is terrible). I want it to be easily managed by the customer so that I don't have to come in and make alterations to the formula every time something changes on their end.

I can't think of a way to do this otherwise, but here is what I was thinking:

List A = Squadron

List B = Wing

List C = Group

Assuming I make each squadron option an entry on List A in order, and I make each wing option an entry on List B (in the order that matches list A) and then do the same thing with List C, how would I make List B and C match the information to List A?

I was thinking that if I made this all choice columns on a singular list, it would still need to be hard coded UNLESS I can figure a way to make like:
List Item A-1 = List Item B-1 & List Item A-1 = List Item C-1

List Item A-2 = List Item B-2 & List Item A-2 = List Item C-2

and so on.

Once again, I know this is hard to understand...it was hard to explain through a message. If you have any questions on what I mean, please let me know..I've tried googling this and I can't quite find an answer.

Categories:

Building Power Apps