Skip to main content
Community site session details

Community site session details

Session Id : m/PdMln767gD0LS3K6ozHM
Power Automate - Process Mining
Unanswered

Parsing columns in a table as individual tasks in the processs

Like (0) ShareShare
ReportReport
Posted on 11 Oct 2023 00:34:52 by

I am new to process mining and looking for some guidance or direction to a great training source. Most all of the tables on our servers record times and activities according to the model below. 

 

Assistance IdInitial IDBegin_TimeDispatch_TimeEnd_Time
 500017/25/2023 18:237/25/2023 18:307/25/2023 19:00
50002500017/25/2023 18:407/25/2023 18:457/25/2023 19:00

 

Explanation:

  • Initial ID is assigned as soon as the process is created (also recorded with Begin Time)
  • Dispatch Time is recorded when is assigned to the process.
  • (IF) The initial person request assistance, then that is recorded by Assistance ID.
  • The same process is added to the process and each task is tacked on to the overall process time.

My Problem:

I am trying to build a process map that will analyze the time between each task and also (when applicable) add times of the tasks that were completed by under the Assistance ID.

 

I know this is a lot to cover, but I searched for a good source and cannot seem to make any headway. Any advice would be greatly appreciated. 

  • Jinman Profile Picture
    Microsoft Employee on 09 Nov 2023 at 18:06:53
    Re: Parsing columns in a table as individual tasks in the processs

    @smithbj, welcome to Process Mining world. 
    @deronu , will you paste some links to here? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete