Sample Submission Form

[kyliehenline]

Hi! I'm looking to make our lab's sample submission easier and think that PowerApps might be the best solution. My goal is to have a link I can send to a customer that will allow them to fill out and submit a form. I would then like the form to populate a spreadsheet that is currently located on Sharepoint. Finally, I'd like the customer to receive an email back indicating the sample number (from the Sharepoint spreadsheet) and me (or someone from our lab) to receive an email letting me know that someone submitted a sample form. Does anyone know if this is possible with PowerApps? If so, any guidance on where I can find help would be much appreciated. I don't have any experience with PowerApps. Thanks!

[BCLS776]

If this is all you need to accomplish, it is possible with Microsoft Forms and the Power Automate integrations. Those are a couple of steps easier than Power Apps, in my opinion, and you don't have to worry about licencing issues with those external customers.

If I can make one suggestion: avoid using Excel as your data source here - a SharePoint List will function much better in the long term.