PL-600 · Question #173
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…
The correct answer is A. Yes. The proposed solution leverages a canvas app for mobile data entry, a cloud flow for orchestrating approvals, and a desktop flow to connect and write data to the on-premises SQL Server database, effectively meeting the requirements.
Question
Options
- AYes
- BNo
How the community answered
(24 responses)- A71% (17)
- B29% (7)
Why each option
The proposed solution leverages a canvas app for mobile data entry, a cloud flow for orchestrating approvals, and a desktop flow to connect and write data to the on-premises SQL Server database, effectively meeting the requirements.
A canvas app provides the mobile interface for users to submit expenses from their devices. A cloud flow can orchestrate the approval process and then trigger a desktop flow, which uses Power Automate's on-premises data gateway, to interact with the on-premises SQL Server database to add the expense data. This combination allows for mobile submission, cloud-based approval, and secure on-premises data integration.
Concept tested: Integrating Power Platform with on-premises data
Source: https://learn.microsoft.com/en-us/power-automate/desktop-flows/connect-sql-database
Topics
Community Discussion
No community discussion yet for this question.