Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

record forms answers to sharepoint multiple entries

(0) ShareShare
ReportReport
Posted on by 143

Hello every,

 

i have a power automate flow that sends an email to certain people asking them to fill a MS Forms.

then i have another flow that records those answers into SharePoint.

Everything works fine up until here. However, some of those people have multiple entries in my dynamics 365  accounts.

For example i have a person with 4 jobs in dynamics 365 so when i send the email he receives 4 emails.

and when he fills the form, my flow records his answer four times.

is there a way to get a different answer for each job ?

thank you

@trice602

  • barbarbar Profile Picture
    barbarbar 143 on at
    Re: record forms answers to sharepoint multiple entries

    Hi @Nived_Nambiar , i sent you the FetchXML query in a private message ,

    Now i am able to record one answer at a time, however it's for the same project.

    any ideas on how to make the manager submit a different answer for different projects?

    do you think i should add something to the form and then compare it ?

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: record forms answers to sharepoint multiple entries

    Hi @robrobrob 

     

    Yes if you can share screenshots that would be better 

    Also for fetchxml query are u using the below condition:

    i need all candidates with an active placement and a job title that contains data and the manager's email + first and last name.

     

    Kindly let me know 🙂

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • barbarbar Profile Picture
    barbarbar 143 on at
    Re: record forms answers to sharepoint multiple entries

    unfortunately that does not work for my case, as i am using FetchXML to filter out the data i need.

    it's a bit more complex. i need all candidates with an active placement and a job title that contains data and the manager's email + first and last name.

    then i select the manager's email using the items(')?['] 

    i can send you screenshots if needed

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: record forms answers to sharepoint multiple entries

    Hi @robrobrob 

     

    You can do one extra step in sending forms so that one person would receive one email at a time irresptive of their number of accounts. Take this below design as reference:

     

    Since i can't reproduce same as your design , let's assume that i have a field in Contacts field named Email Address 2 which is assumed to be the email dynamic content you are using. So i will design the first flow like below

     

    Here , bot will list rows present in contacts dataverse table and then uses Select action to select only EmailAddress 2 like below design :

     

    Nived_Nambiar_1-1692379770107.png

     

     

    Now it will remove the duplicate email ids from the array obtained from select action so that it won't send multiple emails to same person using below expression which is added at Apply to Each loop.

    Nived_Nambiar_2-1692379885527.png

     

    here body('Select_2') represent the array output from select action shown in first screenshot, here the name of select action was select 2. just keep a note of that.

     

    Now inside the loop use the current item as email address of each person to which form request needs to be sent. 

     

     

    This design ensures that bot will send one email at a time to the people.

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌




  • barbarbar Profile Picture
    barbarbar 143 on at
    Re: record forms answers to sharepoint multiple entries

    sure

    Flow 1 to send an email

    robrobrob_0-1692378220195.png

     

    Flow 2 To Record Answers

     

    robrobrob_1-1692378242750.png

     

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: record forms answers to sharepoint multiple entries

    Ok Got it, can i have a look at your flow ?

    @robrobrob 

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • barbarbar Profile Picture
    barbarbar 143 on at
    Re: record forms answers to sharepoint multiple entries

    actually he receives the same form, i cannot create a different form for each job, because there are many people with many jobs , that will mean that i should create 10's of forms . is there a way around that ?

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,076 on at
    Re: record forms answers to sharepoint multiple entries

    Hi @robrobrob 

     

    One doubt in the question, so when he recieve each form filling request via email, it would be expecting different form response as he have 4 jobs as per dyanmics 365 account , right ?

     

    Correct me if i am wrong 🙂

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard