Flow is not triggered when I enter a custom value for the Table name in step When an item is created in SQL, but works when I pick a table from the drop down list

[generalledger]

I am brand new here.  I have Power Automate with RPA license.  Trying to create a Flow that: 

1. When an item is created in SQL on premise (Yes, I have a gateway installed.  Yes, I have a Power Automate connection to the database under Data>Connections)

2. Transforms data using Power Query that returns a single record

3.  Sends an Office email with data from the single record

The first Step asks for the Server Name, Database name and Table name:  

The drop down list for Server name shows my server and I select it. 

The drop down list for the Database name shows the database and I select it. 

The drop down list for the Table name lists about 50 tables but not all 600 tables in the Database.  There is an option to "Enter custom value".  From using the <> Peek Code option of the step, I learned the Table name must be in the format [dbo].[tablename]  So I entered the table name following that format ([dbo].[PersonT]).  I am able to confirm by reviewing the <>Peek Code that it appears to be correct. 

The Flow is not being triggered when a new item is created in the PersonT table.

I tested the Flow by selecting another Table name from the drop down list in the trigger step.  A table that has nothing to do with the purpose of the Flow but where I can enter a new value to see if this Flow can be triggered and that the later steps work.  If I select a Table name from the drop down list, and create an item in that SQL table, the rest of the Flow works fine.  

It seems Power Automate does not like it when you enter a custom value for the Table, even if the custom table is entered in the format of other table names that do work.  Can anyone offer advise?  Thank you very much.

[OliverKr]

Hello General,

have the same problem but nothing happens here 😀. Did you find a solution for this? Have opened a support ticket at MS but they didn't know anything and have to do "further analysis".