Share via

Create a simple form in Sharepoint

Mark Suiter 11 Reputation points
2020-08-17T19:16:31.27+00:00

We are using sharepoint online. I need to create a simple form that will send the results inside the email it sends. I have tried power apps, power automate, dozens of plugins and add-ins, nothing will work. The best I can get is MS forms to display a very poor form but the info does not get collected and it just sends an email that has no content.

Is there ANYWHERE I can download a working template or ANY resource that will show things the way they look and have the same feature available to me on my site?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,186 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nishanth Shreepad 81 Reputation points
    2020-08-18T17:07:11.02+00:00

    You should be able to acheive this using Powerapps and Powerautomate.

    1. Create a form in Powerapps connected to a sharepoint list or any datasource where data can be stored
    2. trigger a power automate when a new item is added to send an email
    3. in power automate create a variable and build an html based on your design and inserting column values from data
    4. Send the created html in the email

    This should ideally work. please let know if you have issues creating html design

    1 person found this answer helpful.
  2. Itch Sun-MSFT 2,556 Reputation points
    2020-08-18T02:01:42.747+00:00

    You can try using infopath form:

    Add a submit data connection

    1.On the Tools menu, click Submit Options.

    2.In the Submit Options dialog box, select the Allow users to submit this form check box.

    3.Click Send form data to a single destination, and then, in the list, click E-mail.

    4.Click Add.

    More information:

    Submit form data in an e-mail message

    In addition, you can also refer to these articles below:

    How do I create a form which sends an email?

    Microsoft Flow Tutorial - Email Notification on Form Completion with Flow

  3. Mark Suiter 11 Reputation points
    2020-08-18T15:11:13.723+00:00

    I was able to get Power apps and flow to work. However the info collected is not correct.
    if you look at the list - the info from the submission is correct.
    If you look at the flow the included content is correct as it pulls directly from eh form and you don;t even have an option to choose the wrong column.
    Column 1 info correct - email and list
    Column 2 info correct - email and list
    Column 3 Not even close to what was submitted on email but correct on list