if one item has value how to have the word In Progress?/

(0) Share

Report

Posted on by bbsin

1,994

I have a gallery - text box status, I like to auto input as In Progress if the Others have amount?

Do I put the text box visible as

If(Amtbox = Value(Amt.text), 'In progress") ???

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bbsin ,

What is the Amtbox? Is it the status text input box?

If so, please try:

Set Default of the Amtbox:

If(Value(ThisItem.Amt.Text) > 0, "In progress", "")

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-jefferni

The status box in SP is a choice field. and it is inputbox in PowerApps.

Is it like that? it does not work. Thx
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin ,

One of the most important points of problems or questions for SharePoint list is column types, things would change a lot when using People or Choice or other special column types. Please provide these important information when you have questions when data source is SP list.

As for your question, the formula should be:

If(Value(ThisItem.Amt.Text) > 0, LookUp(Choices(SPlist.Status),Value = "In progress").Value, Blank())

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Agreed. Thanks for the syntax, it works. 🙂
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

I have a question, as I have a flow for approval going back end, if I use this code. it look like it had hardcode the status.

I just want only when other hv amount to display as In Progress.. this is first time, when invoice amount is approved which is another box, it status will change auto from workflow.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

I have a question
if I use this it is set as a fix it..

If(Value(ThisItem.Amt.Text) > 0, "In progress", "")

how to change the states to complete - as the status are link to a flow once approved expected for InterDept Charge and Purchase, I need it be change to complete when it have these two item and there a amount in invoice Amt. but not affecting the approval flow ..

the example status shld be complete as it's interDept charge with amount in the invoice box and complete box 1# should auto update as NA. Thanks.