@Sarva, Pavan Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.
Yes, HTTP trigger function source code need to be a part of your bicep scripts and your need to pass the function source code using the
files` property under `Microsoft.Web/sites/functions@2022-09-01 resource block.
You can refer to this GitHub sample in which we are deploying dotnet function app with Http trigger and storing the function app keys in the key vault.
Feel free to reach back to me if you have any further questions on this.