if inside switch throwing error

(1) Share

Report

Posted on by Unkn0wn

Hi All,

I'm trying the below code, but idk why it is throwing error

Switch(
 vStatus,
 "complete",
 If(
 IsBlank(
 LookUp(
 delivery,
 ID = vSelectedID,
 Version = "completed"
 )
 ),
 Patch(
 delivery,
 {ID: vSelectedID},
 {Status: "completed"}
 ),
 Notify("already order is completed",NotificationType.Error)
 ),
 "finalize",
 Patch(
 delivery,
 {ID: vSelectedID},
 {Status: "finalized"}
 )
)

if i'm writing the if condition part outside of switch. it is fine.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

I think that the problem is missing you a default. Not the if...

Switch(
vStatus,
"complete",
If(
IsBlank(
LookUp(
delivery,
ID = vSelectedID,
Version = "completed"
)
),
Patch(
delivery,
{ID: vSelectedID},
{Status: "completed"}
),
Notify("already order is completed",NotificationType.Error)
),
Patch(
delivery,
{ID: vSelectedID},
{Status: "finalized"}
)
)

Was this reply helpful? Yes No
Unkn0wn 48 on at

Like (0)

Report

@Nogueira1306
Hi I've tried the same as well. but no luck i dont think its because of default

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report

Show me the error

Was this reply helpful? Yes No
Unkn0wn 48 on at

Like (0)

Report

@Nogueira1306

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
If( IsEmpty( LookUp( delivery, ID = vSelectedID, Version = "completed" ) ), Patch( delivery, {ID: vSelectedID}, {Status: "completed"} )

Was this reply helpful? Yes No
Unkn0wn 48 on at

Like (0)

Report

@Nogueira1306 thanks for response
tried with isempty & isblank with filter as well but no luck

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Unkn0wn,

The issue stays?

I have a test on my side, and I found key to this issue is indeed the invalid argument.

The If() statement inside the Switch() returns a record if the condition is true, but it will display a banner message if the condition is false, which is not a record of data type. In addition, the second formula to be evaluated for matching returns a records, that's why the error message said that it expects a record value. You should keep all the returned result is a record in the If() statement.

I personally don't recommend mixing Switch() and If() in the same function unless you keep all the returned data type same.

On your side, I suggest that you could replace the Switch() with the If() as below:

If( vStatus="complete",// Use the If() If( IsBlank( LookUp( delivery, ID = vSelectedID, Version = "completed" ) ), Patch( delivery, {ID: vSelectedID}, {Status: "completed"} ), Notify("already order is completed",NotificationType.Error) ), vStatus="finalize", Patch( delivery, {ID: vSelectedID}, {Status: "finalized"} ) )

Hope this could help you.

Was this reply helpful? Yes No