moving Milestone to next milestone based on milestone status

(0) Share

Report

Posted on by Surajde

Hi all,

I need your help to move Milestone to next milestone based on milestone status.

for that I've used blank horizontal gallery.

Milestones for all 4 Areas are same. however Project A,B,C & D will move forward only upon completion of the milestone.

But each project will have its own set of same milestones to reach.

Project A

Project B

Project C

Project D

Milestone 1

Milestone 2

Milestone 3

Milestone 4

Milestone 5

in above scenario Projects moved forward based on completion of the milestone.

there are many status of the milestone i.e. "In-progress", "Blocked", "Complete", "Not Yet started"

please help with formula that can help move project forward once it is in Complete status.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Kirkby 647 Moderator on at

Like (0)

Report

Hi @Surajde
Since each person has their own preferred way, the implementation methods are expected to vary.
My approach is to use a simple data structure as follows.

The below code is placed within a button 'Populate' in this example.
Data will be retrieved from your repository and collected to a collection in real situations. The list of milestones(ColMilestoneList) or status(ColPrjoectMilestonesStatus) does not have to be collected if the data structure is simple.

Concept for setting status. 4 check boxes for status were used to help understanding.
Milestone is ready to go next when its status is complete. (Other features like current status is reflected to check box have not been added yet). Properties of Visible

Concept: Milestone and its status are updated when the checkbox is clicked.
(If you define the first status next to the previous status 'complete' in advance, a user does not have to select a status among 4 check boxes.)

The above gallery that shows status by each project is rendered again.
Updating the status and milestone of the selected project
(There is a step required to save the updated status value in the Gallery when a user changes a status, but that step has not been implemented)

I hope it helps.
(If you found my answer helpful, I'd appreciate it if you could mark it as 'Accept as solution' or give it a thumbs up.)

Was this reply helpful? Yes No
Surajde 99 on at

Like (0)

Report

@Kirkby this idea is good. But in our condition., Milestone should be automatically moved to next milestone previous milestone is completed.

Was this reply helpful? Yes No

Surajde

99 on at

Like (0)

Report

@Kirkby

Can you please use below table data and help set this like image shown in the bottom here?

Key_ACCOUNTS	Key_Area_Status	MILESTONE_NAME	Milestone_Rank	DUE_DT	STATUS
Project A	Implementation	Identification of scenarios	1	7/26/2023	Complete
Project A	Implementation	Data Categorization	2	8/9/2023	Complete
Project A	Implementation	Data Training	3	8/21/2023	Complete
Project A	Implementation	Testing	4	9/21/2023	Complete
Project A	Implementation	Synch up	5	9/25/2023	Complete
Project A	Implementation	Deployment	6	10/10/2023	Complete
Project B	Implementation	Identification of scenarios	1	7/26/2023	Complete
Project B	Implementation	Data Categorization	2	8/9/2023	Complete
Project B	Implementation	Data Training	3	8/21/2023	Complete
Project B	Implementation	Testing	4	9/21/2023	Complete
Project B	Implementation	Synch up	5	9/21/2023	In Progress
Project C	Implementation	Identification of scenarios	1	7/26/2023	Complete
Project C	Implementation	Data Categorization	2	8/9/2023	Complete
Project C	Implementation	Data Training	3	9/21/2023	In Progress
Project C	Implementation	Testing	4	9/22/2023	In Progress
Project C	Implementation	Deployment	6	10/5/2023	In Progress
Project C	Implementation	Synch up	5	9/25/2023	In Progress
Project D	Implementation	Identification of scenarios	1	7/25/2023	Complete
Project D	Implementation	Data Categorization	2	8/9/2023	Blocked
Project D	Implementation	Data Training	3	8/21/2023	Blocked
Project E	Implementation	Identification of scenarios	1	7/26/2023	Complete
Project E	Implementation	Data Categorization	2	8/9/2023	Complete
Project E	Implementation	Data Training	3	8/21/2023	In Progress

milestone summary:

Was this reply helpful? Yes No

Surajde 99 on at

Like (0)

Report

@Kirkby @Reza

Can you help?

Was this reply helpful? Yes No
Surajde 99 on at

Like (0)

Report

@Kirkby @Reza Please resolve this. Need this one high priority.

Was this reply helpful? Yes No