cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RajeshLohar
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.

Thanks,

2 REPLIES 2
manuelstgomes
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.

Cheers
Manuel

I am using Common Data Service and joined two entities.

 

Thanks

Helpful resources

Announcements
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,205)