Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Form submission data collection

(0) ShareShare
ReportReport
Posted on by 2

Dear All,

 

I wanted to build a flow which will collect the information from users email and generate automatic email reply. Along with that id like it to store the info in sharepoint in an excel sheet. 

 

1) User submits form

2) User gets automatic email saying the email has been received

3) The task of form is created and emailed to the DL group

4) Form submission is saved in sharpoint in an excel format

4) Respond to the email and user gets reply

5) Once replied task should close

 

Thanks in advance hopefully this is some that can be accomplished. 

 

 

  • wreched83 Profile Picture
    2 on at
    Re: Form submission data collection

    Hey Anna,

     

    Thank you so much for the reply and flow it looks fantastic. So to those questions my group would reply to the auto generated email that was sent to them and it would essentially complete the task. 

     

    So here is what I am envision if at all possible, our form is a billing inquiry form. When the submitter fills the form out he/she will receive an auto generated email, along with our team getting an email but id like the list of questions in the body if possible and a task to be created. From there Id like the questions to be in excel and stored in sharepoint, once someone in the group replies back to that email would it be possible for the task to show as completed? 

     

    As for the special dates, I only add what is on the form, I am using microsoft forms and they have the date option there if that is what you were referring to? 

     

    Thank you again for all the help!!

  • v-duann-msft Profile Picture
    on at
    Re: Form submission data collection

    Hi @wreched83 

     

    Thank you for posting.

     

    According to your description, you would like to gather form response and create task as well as inform user via email. I understanding the first 4 steps and create flow overview for you. Please check first.

    v-duann-msft_1-1616651002628.png

     

    However, I’m confused about your last two requests.

    4) Respond to the email and user gets reply

    Which email to response ? What do you mean by user gets reply? What’s the reply ?

    5) Once replied task should close

    What do you mean by task close? Do you mean task completed ? Who reply ? Reply to what ? Do you mean user manually reply or some automate reply setting ?

     

    By the way, may I know your form settings to make sure no special kind of data inside.

     

    If I can confirm for information above, I should be able to create the whole flow for you.

     

    Hope to hear form you soon.

     

    Best regards,

    Anna

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow