web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Changing status drop d...

Power Apps

Answered

Changing status drop down automatically

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

So, I've been having a problem with my Power Apps form which contains a drop down field titled 'status'. The status has 4 options: New, Approved, In Review, Rejected. I want each of these options to be relative to what is happening in the form.

- I want the status to be 'New' whenever the form is created but not submitted.

- 'In Review' when the form has either just been submitted or is awaiting a second,third, or fourth approval (I have a staged approval system of 4 people)

- 'Approved' when the final approver approves the form.

- 'Rejected' when either one of the approvers reject the form.

Please feel free to ask me if you have any questions.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Anchov 1,986 on at

Like
a
(1)

Report
Copy link

Link copied!
You will need to set you set your business logic in a status variable prior to the SubmitForm action of your form. You will have different conditions to be satisfied to determine each status that needs to be updated. For Example:

//This logic saves the form sets the Status to "Draft" if the Submit button has not been clicked on If( varCurrentRecord.Status.Value <> "Submitted", Set( varSetStatus, {Value: "Draft"} ); ); SubmitForm(form1)
Then, the Default property of the Status drop down is set to:
If( !IsBlank(varSetStatus.Value), varSetStatus, ThisItem.Status )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No

Join the conversation