Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Process Mining
Unanswered

Parsing columns in a table as individual tasks in the processs

(0) ShareShare
ReportReport
Posted on 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 at
    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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Process Mining

Overall leaderboard