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

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,020)