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

[@andreschavarro]

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

[@Weatemilly]

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

[@PowerUserJ]

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