Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Guidance on Designing Business Process Flows Across Two Tables

(0) ShareShare
ReportReport
Posted on by 257

Hello,

I’m working on a Business Process Flow (BPF) that spans two key tables:

  1. Project Request Table: Where project requests are created and initially managed.
  2. Project Table: Where approved requests are tracked through their lifecycle.

Here’s the setup I’ve tested:

  • Created a BPF starting with the Funnel stage in the Project Request Table.
  • Added a condition that evaluates the Workflow Type field in the Project Request Table form:
    • If Workflow Type = Project, the flow transitions through project-specific stages.
    • If Workflow Type = Efforts, it transitions through effort-specific stages.
  • Activated this BPF and added it to my model-driven app as an automation.

Issue:
The BPF works well when creating a new project in the Project Request Table form. However, once the project is approved and data is copied to the Project Table via Power Automate, the BPF does not carry over.

Goals:

  1. Seamlessly integrate the Funnel stage and automate the transition between the tables.
  2. Maintain continuity across stages and tables.
  3. Ensure the BPF is visible and functional in both tables for a smooth user experience.

Request for Help:
What are the best practices for:

  • Designing BPFs that span multiple tables and stages?
  • Managing Workflow Type-based transitions within the BPF?
  • Ensuring BPF continuity and visibility across both tables/entities?

Any insights or resources would be greatly appreciated!

 

 

 

  • mccardj3 Profile Picture
    mccardj3 20 on at
    Guidance on Designing Business Process Flows Across Two Tables
    Hi there,
     
    What table have you assigned to the Reviewing and Backlog stages? It should be the Project Table based on your requirements.
     
    I use BPF all the time because they provide a better UX than forms alone. As you move from stage to stage, the BPF will appear at the top of the form.
     
    If you could please provide more screenshots and or a video demonstrating what you're seeing on the form that'll be helpful.
     
    Thanks,
     
    Jack

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics