Answered

Update the color of Process stages once the process is done......

(0) Share

Report

Posted on by Vinodhini

In my application I have three process stages

1.Employee -- once employee submits all the forms in our application we have a yes button for final submit in separate page. After Final Submit the mail will send to manager for approval(Through the yes button we trigger the flow for send an email) ....After employee click the yes button ......We have process stages.......The color of employee stage should turn into green.....

2.Manager---After manager click the button of approval ....Hr will get mail for approval....That time Manager stage color should be change to green

3.Hr----After Hr submits the reports of employee ...employee will get mail and the color of Hr stage should be change

In dataverse we have a list of Employee details......I need to update the process stages color based on particular user which was selected by manager for approval

Can anyone Suggest any solution for this......

And we have one more also .....For Employee stage....Once the employee click the Final submit yes button ....All the forms in our application should not be editable.....Means The forms should be in view mode.

@Thanks in Advance.

Categories:

Power Apps portals

All responses (6)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Vinodhini ,

Could you please share more details about your scenario? Is the app a portal or a Canvas?

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.
Vinodhini 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,
Canvas App
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vinodhini ,

So if you have a column in the list for saving the status of approval/stage, you can set the Fill of the control with If statements based on current stage of the item.

For example, under the premise that there is a Stages column is of type number, where will have numbers 1-5 representing as all the stages, then the Fill property of the "Employee" Rectangle or Label will be set as follows:

If(ThisItem.Stage < 2, Green, RGBA(0,0,0,0))

other controls are as the similar.

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.
Vinodhini 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,
First of all thank you for your valuable reply. Based on your reply half of the problem was resolved.
Ofcourse your solution is working on single user....I need some more clarification also.
As you mentioned we have Status column and the value is Approved/Pending .......
Based on the Login user .....The stages should be update right?
We have a Employee Name column in dataverse.......
Actually the main thing is Based on login user how can we fetch status of user.....

Id Employee Name Stage
1. Vinodhini Pending
2. Jefferni Approved

Consider The login user is me..........Now User().Full Name=Vinodhini
Based on Login User I need to fetch the data in dataverse.....That means we need to fetch the two Columns same time....For that I tried something ....But it is showing error .....Could you please give any suggestion for this

For Reference I have added two images .....Here the Employee Details is the Table name and the Status2 is the column for storing the Status value of employee.....

Thank You
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vinodhini ,

I cannot understand your scenario very clearly. What will those controls to do with the logged in user? As you mentioned managers and HR will select an employee to do approvals, but logged in user is always the user who are using the app. If you would like the app users to see current status of themselves, you can just search the employee table to get the record belong to the user and check the status. Formula like below:

If(LookUp('Employee Details', 'Employee Name' = User().FullName, Stage.Value) = "Approved", Red, Blue )

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.
Vinodhini 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,
Actually you got my requirement.....The Lookup Function is working Perfect
I was stuck with Lookup function.....Now the issue got resolved.....
Thank you very much for your valuable Reply and Time