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

[RajeshLohar]

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,

[manuelstgomes]

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

[RajeshLohar]

I am using Common Data Service and joined two entities.

Thanks