Let’s make something together

KAISPE has been providing solutions and services to customers using Microsoft Dynamics, Azure, Power platform, Oracle NetSuite, mobile and web app development.

    • US OFFICE
    • +1 315 791 4472
    • KAISPE LLC
      590 Madison Avenue 21st Floor Manhattan, NY 10022 USA.

 

  • PAKISTAN OFFICE
  • +92 213 432 6085
  • M/S KAISPE
    Suite#213 Sumya Business Avenue MACHS Karachi, Pakistan.

Integrating PowerApps with Microsoft Dynamics 365 F&O

  • August 12, 2021
  • 443 Views

Hi, we had a scenario where one of our customers is using On-premises version of Microsoft Dynamics 365 F&O and we had to connect one of our PowerApps app with F&O.

Customer wanted to perform all of the Purchase Requisition Operations (read, write, update, delete) from PowerApps App into On-premises Microsoft Dynamics 365 F&O without using the Power Platform Data Gateway.

Some of the Dynamics 365 F&O entities that we used in this integration are mentioned below:

  • PurchaseRequisitionHeaderV2Entity (GET, PUT, POST, PATCH)
  • PurchaseRequisitionLineEntity (GET, PUT, POST, PATCH)
  • HcmWorkerEntity (GET)
  • VendVendorV2Entity (GET)
  • EcoResReleasedProductV2Entity (GET)
  • OfficeAddinLegalEntityEntity (GET)
  • CurrencyEntity (GET)
  • EcoResProductCategoryAssignmentEntity (GET)
  • EcoResEveryProductEntity (GET)

So we started looking into this and proposed the high-level architecture on how we can integrate Microsoft Dynamics 365 F&O with PowerApps Canvas app and Power Automate.

  • We created a web service and host to the public cloud to Push and Pull data from on-premises Microsoft Dynamics 365 F&O.
  • We then created a Custom Connector for the hosted web service in Power platform.
  • Used the created custom connector in PowerApps and Power Automate.