I want to create a power app that can perform crud operations in a SQL DB table without using any premium connectors such as SQL connectors in the power apps or flows.
Hello @Anonymous
You can explore Azure Logic Apps, Azure Functions, and Microsoft Graph API.
An idea I used to think of was to store data in SharePoint and use an Azure Function to access SharePoint via Graph API. I think it's doable but requires a lot of work and extensive knowledge in order to get your data protected. I did give up because time is more valuable in my personal scenario. Also, Azure Function is not totally free.
Oh, one more thing, maybe learn PCFx (Power Apps Component Framework), its ReactJS base. Theoretically, you can design an interface that may be able to connect to your SQL server.
Both are long shots, good luck! 🍀
✔️ | Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future. |
🔗 | 🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace |
Share
Report
All responses (
Answers (
4,932
