Unanswered

Using switch and a lookup

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. Having an issue where I am trying use a lookup formula inside switch. The switch portion of the code works when I use it alone, and the Lookup portion works as well when its alone, just not together. No errors at all are being shown, but it is only displaying the switch function up to the Lookup.

Switch(
ThisItem.Status,
"Transfer",
"This game must be received at the receiving store no later than 7/15/22",
"Sell",
"Game sale will be handled by your EAM",
"Part",
"Game will be parted and parts sent to depot NLT 7/15/22",
"Part-Out",
"Game will be parted and parts sent to depot NLT 7/15/22",
"Depot",
LookUp(
DepotStatus,
Title = ThisItem.GameName,
Column2)

Thanks everyone!
Chris

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

zmorek 3,272 on at

Like (0)

Report

It might just be a relic of copy/pasting but you're missing the final closing parenthesis for the whole Switch(); for your LookUp(), what is Column2?

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report

Hi @zmorek , thank you for the quick reply! The closing parenthesis is there in the app, just missed on the copy and paste! Column2 is what I am trying to return if ThisItem.Status = "Depot" I added a screen shot for clarity.

Chris

Greenshot 2022-04...

Was this reply helpful? Yes No
jriemsma 11 on at

Like (0)

Report

But what kind of data is IN Column2. All of the other result values are 'single line of text' (strings). I think zmorek was asking about the 'Content Type', of Column2. Number, Text, Date?
Also noticed that your formula relies on the Game Name existing in the lookup table 100% of the time. You may wish to add the optional 'default result' for the switch statement.

Was this reply helpful? Yes No
ckserra33 421 on at

Like (0)

Report

@jriemsma Got it. It is a single line of text. From a SP list. Thank you for the help!

Was this reply helpful? Yes No