We have a Azure SQL server database I need to connect to it using Azure Active Directory - Universal with MFA. I can connect the DB with SSMS. Also my Power Apps is able to connect. However I cannot setup Power Automate SQL action "when an item is created (V2)". I picked authentication type = Azure AD integrated. I type in the SQL server name and DB manually (because it is not shown in the dropdownlist) and not able to list the tables. What should I do?
MFA requires a "manual" portion of the process to be present. Unless you can emulate that (various hints on the interwebs) you must find a different authentication process.