Missing Stored Procedures

[iwonder]

Thank you for taking the time to read my question.

I created 2 SQL Stored Procedures yesterday. I waited several hours for them to be available in Flow but they did not show up. I checked again this morning and they are still not there. I can see one function I created in my db but not the SP's so I know it's connecting to the DB.

Is there something I need to do to make them show up in the list?

 

Thanks!

[Gopala_Krishna]

@iwonder 

I suggest you to try below steps and check if that helps in resolution of the issue

- Click on enter custom value in the procedure name and enter the name of the SQL procedure that you have created manually. Once you start executing the flow it will try detecting the name automatically.

- Try adding a new connection by clicking on the the three ellipses (...) present on the action card and click on + add new connection once you add the new connection you will be able to see the name of new stored procedures that you have created

- Try remove the action card from the flow and re-add it once again or try creating a new flow from scratch.

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

[iwonder · Accepted solution]

Hi Gopala,

I managed to get my admin involved and they provided extra permissions just now. The stored procedures were available a few minutes later.

Thank you so very much for your reply. I really appreciate it.

[Anonymous]

What were the permissions that you needed added? I am running into the same issue. 

[Anonymous]

Figured it out. The permissions need to be set on the stored procedure with in SQL server. 

[Anonymous]

Thanks KnuclesUP,

for me was in this tab on SQL 

Kind Regard,

F.