How to connect with "Microsoft Power Apps" or "Microsoft Dataverse" using "SAP Open Connectors"

[koide_yuya]

Hello
As the title suggests, I would like to know how to connect to "Microsoft Power Apps" or "Microsoft Dataverse" using "SAP Open Connectors", a feature of "SAP Integration Suite".

If you look at the "SAP Open Connectors" catalog, you will see "Microsoft Office 365" and "Microsoft Dynamics 365", etc., but can you connect using these?

As an example of usage...
I want to create something that will allow "SAP Integration Suite" to retrieve the information that is sent when a button in "Microsoft Power Apps" is pressed.

I would appreciate it if anyone with knowledge or experience with implementation could tell me.

Best Regards.
Yuya

[Martin-Pankraz · Accepted solution]

Hi @koide_yuya,

PowerApps interactions triggered by Buttons etc will point at PowerAutomate flows. From there you are free to trigger iFlows on Integration Suite as you like using the plain http connector for instance (push-based scenario). On PowerAutomate you may also retrieve the info from your app or do additional pulls from Dataverse that you want to pass along to your iflow.

SAP Open Connectors would be needed for pull-based scenarios from your iFlow.

Let the community know what you decided in the end.

Cheers Martin

[koide_yuya · Accepted solution]

Hi @Martin-Pankraz 

Thank you for your reply.
Recently, I started studying "Integration Suite" and "Microsoft Power Platform".
For that reason, I'm sorry that my understanding is insufficient.
Therefore, I would like to ask the following questions again.
① Push type scenario
(1)Click the button installed in Power Apps. (trigger)
(2) Power Automate will start and retrieve the preset "Dataverse" data.
(3) Obtain information using "Cloud integration (integration flow)" for which HTTP connection settings have been made in advance from the "HTTP connector" set in advance in Power Automate.
(*Are you not using "SAP Open Connectors" or "SAP API Management"?)

②Pull type scenario
(1) Actions on the “Integration Suite” side (event mesh, etc. (trigger))
(2) Connect to “Dataverse” using “Cloud Integration (Integration Flow)” (*Using “Open Connector”?)
I couldn't figure out how to connect to "Microsoft Power Automate" or "Dataverse" using "Open Connectors".

I would like to know more details if possible.
Best Regards.
Yuya

[koide_yuya · Accepted solution]

Hi @Martin-Pankraz

Thank you for your reply.
Recently, I started studying "Integration Suite" and "Microsoft Power Platform".
For that reason, I'm sorry that my understanding is insufficient.
Therefore, I would like to ask the following questions again.
① Push type scenario
(1)Click the button installed in Power Apps. (trigger)
(2) Power Automate will start and retrieve the preset "Dataverse" data.
(3) Obtain information using "Cloud integration (integration flow)" for which HTTP connection settings have been made in advance from the "HTTP connector" set in advance in Power Automate.
(*Are you not using "SAP Open Connectors" or "SAP API Management"?)

②Pull type scenario
(1) Actions on the “Integration Suite” side (event mesh, etc. (trigger))
(2) Connect to “Dataverse” using “Cloud Integration (Integration Flow)” (*Using “Open Connector”?)
I couldn't figure out how to connect to "Microsoft Power Automate" or "Dataverse" using "Open Connectors".

I would like to know more details if possible.
Best Regards.
Yuya

[Martin-Pankraz · Accepted solution]

Yes, for the "push" you directly point at Integration Suite. Up to you if you need to front it with SAP APIM. For pull-based you may use the Dataverse Web API. That is plain OData and can be called with SAP's standard oData connector. No need for OpenConnectors. Alternatively, use Azure Data Factory to move the data from Dataverse to SAP