Mastering Power Apps: Invoke Azure SQL Stored Procedures within Power FX  

Hello, insightful video, excellent work. Can you please elaborate on the necessity of the input parameter? I know if there is no input parameter the table comes up as "?". Do you know a way around that, that doesn't require adding the ALTER PROCEDURE. For instance, if it was just a SELECT statement as the stored proc. Ty

Best part is you don't need to put it in collection, just have it as a source in gallery's items property.

Thanks for the video. My question is how to show the sproc results in a dropdown?