Unanswered

Sample Submission Form

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

BCLS776 8,994 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
kapildubal 6 on at

Like (0)

Report

Hi were you able to create this list? how did you manage to connect to data source which in internal and cant be shared with users outside the organisation?

Was this reply helpful? Yes No
kyliehenline 9 on at

Like (0)

Report

Yes! I used a SharePoint list. That was the only way I could figure out that would automatically assign numbers for incoming submissions.

Was this reply helpful? Yes No
kapildubal 6 on at

Like (0)

Report

Hi Kylie, I want to do something similar. I created a list for our internal customers whre they can enter sample information and tests requested. If you dont mind would you be able to send me an example of what you did?
I have just started exploring this option for my purpose. Any input would be highly appreciated.
Kapil

Was this reply helpful? Yes No
kyliehenline 9 on at

Like (0)

Report

Sorry for the delay. I used a Microsoft form and the Power Automate program would grab inputs from that and put them into the SharePoint list. Here is what my Power Automate flow looks like:
I hope this helps.

Was this reply helpful? Yes No