Answered

how to use IF condition in PowerApps ..?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

always if true condtion is executing but not else part what is the wrong here

but no error/warning in form.

If(IsBlank(flag1.text) && IsBlank(flag2.Text) && IsBlank(flag3.Text),Set(flag1,"Approved");SubmitForm(UserApproveForm_SP),
If(flag1.text="Approved"&& IsBlank(flag2.Text) && IsBlank(flag3.Text),Set(flag2,"Approved");
SubmitForm(UserApproveForm_SP)));

here till here it was in true part if you observer from the above code: If(IsBlank(flag1.text) && IsBlank(flag2.Text) && IsBlank(flag3.Text),Set(flag1,"Approved");SubmitForm(UserApproveForm_SP)

updating flag1 value fine but after that second stage it has to excute else part but not excuting.

always even if falg1 value is approved.

else_value part is (which is not executing)

If(!(TextInput1.Text="") && IsBlank(DataCardValue2.Text) && IsBlank(DataCardValue1.Text), Set(secondapp,"Approved");
SubmitForm(UserApproveForm_SP)))

Inshortly: I have 3 flag columns in SP List

Initially i have to check all the 3flag columns are blank or not

if yes(3 flag columns are blank)

Update/set flag1 with approved

Next stage

if flag1 is approved and flag2,3 are empty then

Update/Set flag2 with approved

if flag1,2 are approved and flag3 is empty

then Update flag3 with approved

kinldy correct, and share.

Appriticated for your reply.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The right syntax of If statement shoule be like:

If(condition1,result1,

condition2,result2,

condition3,result3)

So beased on your description, try this formula:

If(IsBlank(flag1.Text) && IsBlank(flag2.Text) && IsBlank(flag3.Text),Set(flag1,"Approved"),
flag1.Text="Approved"&& IsBlank(flag2.Text) && IsBlank(flag3.Text),Set(flag2,"Approved"),
flag1.Text="Approved"&& flag2.Text="Approved" && IsBlank(flag3.Text),Set(flag3,"Approved"));
SubmitForm(UserApproveForm_SP)

Here's a doc about if statement for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

working but values are not loading during form submitting.

Was this reply helpful? Yes No