web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parsing columns in a t...
Power Automate
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. 

Categories:
I have the same question (0)
  • Jinman Profile Picture
    Microsoft Employee on at

    @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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 378

#2
Valantis Profile Picture

Valantis 329

#3
David_MA Profile Picture

David_MA 283 Super User 2026 Season 1

Last 30 days Overall leaderboard