Forum Discussion
Newbie Help With Forms
You can't really do much of this with Forms. It's too basic of a program. What you would need is PowerApps connected to a SharePoint list. The problem is you can't collect data anonymously over the internet with Powerapps.
If this is someone you work with a lot thou. You might be able to look into Setting up a SharePoint site to collect this information, then inviting them as external guest to your site. They would require a Microsoft account to gain access but "I think" they will be able to then go to an orders list, to place an order using PowerApps customized attached SharePoint form. Def. not something that is going to be easy but it's doable if it's a close partner you work with all the time.
If it's something that could be random customers over time that processes would be problematic and I would suggest the SharePoint idea, but possibly look at K2, or Nintex Forms which can give you anonymous form functions and are highly customization.
If this is someone you work with a lot thou. You might be able to look into Setting up a SharePoint site to collect this information, then inviting them as external guest to your site. They would require a Microsoft account to gain access but "I think" they will be able to then go to an orders list, to place an order using PowerApps customized attached SharePoint form. Def. not something that is going to be easy but it's doable if it's a close partner you work with all the time.
If it's something that could be random customers over time that processes would be problematic and I would suggest the SharePoint idea, but possibly look at K2, or Nintex Forms which can give you anonymous form functions and are highly customization.
Christopher, Firstly Thank you for your response it is very much appreciated.
About 20 minutes after my post I started messing around with powerapps and the same realisation dawned on me.
It is a loyal customer and it is only for them that I wanted to introduce a system as they order from us several times a week.
Thank You for the suggestions of K2 and Nintex I will have a look into them.
I guess I could build a powerapp for myself to pump out the quotes, and just get them to fill in a form made in forms as a work around.
Would I be able to send them a form once which they could fill in for each enquiry?
OR
Should I make up a form on word or similar that they can just fill save as and send across each time?
- Well you can have Microsoft Flow handle the invoice instead of powerapps if that is the case, because you can have forms kick off a Flow when someone submits the form. Then you can have that do some magic, then turn around and spin up an invoice via e-mail.
But yeah if you create a form. They can just keep using the same link to fill it out. The data will just keep going to the back end in forms, OR if you connect it to a Flow, you can **bleep** it to a SharePoint list or a whole host of other systems using a connector.Christopher, Thank You again!
That is a very good suggestion...the trouble with 365 and other similar ecosystems is that there are 10 ways to do everything so thanks for suggesting a less manual way forward.
Are you suggesting that I create a flow which triggers the powerapp to run once the form is submitted and produce and email the quote?
SharePoint...connectors...I have yet to get very far in my learning!
I am still wondering whether to use one drive to store and access files, or use sharepoint.
I created a sharepoint site today just to have a play around with it, but I am unsure if I should create one per customer and then have the project files / task lists etc within that or whether to just have the one main share point and create a document folder for each customer (mirroring my current file explorer one)
Powerapps is really just for user interaction so you wouldn't send it to powerapps unless you are using it to make changes or calculate the invoice manually. If it's basic math stuff etc. you can set rules etc. and actions/conditions in flow, you don't need powerapps at all. Use forms to collect the data, then a flow that has "When new form submission happens" take that data and do x with it using the functions etc. in flow, then you can take those variables etc. and use an action to send an e-mail back to the person submitting it using the variables you generated from taking that data in.
