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

How to fetch data from a view of an entity in Microsoft Flow

I have to get data from a view in Microsoft flow, but I do not have any option in MS flow to get this done. I want to fetch relational data like by joining two entities on common field and fetch records from both the tables. It is similar to inner join in SQL. 

I want this in MS flow.

Please suggest a best solution.


Community Champion
Community Champion

Hi @RajeshLohar 


I would recommend creating a stored procedure with those joins and then call that in Power Automate. Then, in case of changes in the database, you don't need to change the Power Automate.


If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


I am using Common Data Service and joined two entities.



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.

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,693)