Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

List rows in Dataverse based on active business process flow stage

Hey there,


I have an table called "projects" and a business process flow "projectphase" which we use to determine the current tender status (Lead, Identify or Quote).

I am trying to list all rows from the "projects" table which are currently in the "quote" projectphase and display the information in an HTML table.


I can't find a way to do this. Basically, I am able to list all rows from the "projectphase" table which contain a certain activestageid_value. When I create an HTML table, I am able to display the names of projects in the "Quote"-Projectphase. I'm unable to fetch more information tho because the projectid is the only informationen referenced in the "projectphase" table.


Is there a way to use these fetched projectids (for example 6 in Total) to list rows of within the project table to retrieve more information about the projects?


Kind regards



Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (4,897)