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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Guidance on Designing ...
Power Apps
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!

 

 

 

I have the same question (0)
  • mccardj3 Profile Picture
    20 on at
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard