
Hi All,
I have a power automate which need to insert data in SharePoint and in SQL server, i know to insert data in sql table we would require per user or per flow license, to run the flow smoothly, but can i use a "service account" to run and share the flow with others?
If yes, how can i do that, i see some unknown issue that is, when i have two actions in a flow one for inserting a record in SharePoint and other to insert record in SQL table and share it with other users its not getting executed and throwing an error, but the same flow executes for me, but when i remove SharePoint insert action, the flow executes fine for other users
my question is what kind of licenses are required for power automate to execute both the actions, do i need per user/App license for all the users or can i go with service account, the trigger will happen from PowerApps