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,
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
15 | |
13 | |
13 | |
10 | |
10 |
User | Count |
---|---|
32 | |
26 | |
18 | |
12 | |
12 |