Azure SQL: can we grant 'execute' permission for stored procedure to API connections in logic app?

Question

I want to execute the stored procedures from the logic app.

I have added an SQL connector for it. but in the 'Procedure name' dropdown, that particular procedure is not visible to me.

do I need to get permission from the admin, to grant execute permission for the stored procedure for a particular API connection? or do I have to get permission for any other objects/azure services?

I added permission to the logic app resource group but still, a stored procedure is not visible in the dropdown.

Thanks in advance!