cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
terramorphous
Advocate II
Advocate II

Can't choose SQL Table when trigger is "SQL - when element is edited"

Hey community,

 

I have created a flow with the trigger "SQL - when element is created", where I can select one of my SQL tables.
Now I want to create a flow with the trigger "SQL - when element is edited", but there is only "no elements" instead of my SQL tables. 
 
The connection is the same as the first one.
 
Thanks for your help!
3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @ bangorkeith,

 

Have you problem still exists?

Could you please share a screenshot of the configuration of your flow?

 

I afraid there is something wrong in your connection. 

Please check if you have created a effective connection to your SQL.

 

You could take a try to create a flow with trigger "SQL - when element is created" , and see if the flow could run to check if the connection to your SQL is  effective.

 

Please let me know if your problem could be solved.

 

Regards,
Alice Zhang

Hi @v-yuazh-msft,

 

Thanks for your reply.

 

The flow with the trigger "SQL - when element is created" has a connection to my SQL and works fine.

 

 

The only problem is the flow "SQL - when element is edited", where the same connection is used.

I can not select any SQL tables here. The custom value doesn't work as well.

 

 

Regards

Up

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,191)