Skip to main content

Notifications

Power Automate - General Discussion
Answered

Add Responders' Email from MS form to SharePoint list and use lookup columns

(0) ShareShare
ReportReport
Posted on by

Hi all,

@v-xiaochen-msft 

I have two SharePoint lists below:

 

LIST2: ‘DisplayName’ and ‘Company Name’ are text type columns.
LIST1: save data from LOOKUP form, ‘Email’ = Responders' Email (Email address of responder who submitted the form). ‘Company Name’ is a lookup column form the LIST2

kinghnvn_0-1669864701037.png

My flow is below:

kinghnvn_1-1669864745480.png

 

kinghnvn_2-1669864808205.png

Company Name Id field: items('Apply_to_each')['ID']

It's now working now and I don't know where I went wrong, could you please check and advise?

 

Thanks.

  • kinghnvn Profile Picture
    kinghnvn on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    I tried to delete the lookup columns and add it again, it works fine now, thanks.

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi @kinghnvn 

     

    Is your Email column changed by Title column?
    In general, we do not recommend modifying sharepoint column names, which will cause many unknown errors, you can try to add a text column named Email.

     

    Best Regards,

    Levi

  • kinghnvn Profile Picture
    kinghnvn on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    No Sir, it's showing the Title only

     

    kinghnvn_0-1669875510550.png

     

    kinghnvn_1-1669875533188.png

    kinghnvn_2-1669875551846.png

     

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi @kinghnvn 

     

    Do you have Email in your dynamic content, maybe you can use Email instead of Title.

     

    Best Regards,

    Levi

  • kinghnvn Profile Picture
    kinghnvn on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    I have just double check and update the same the title name is Email but still the same the issue.

    Can you please check again?

    kinghnvn_0-1669873725829.png

     

    kinghnvn_1-1669873755835.png

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi @kinghnvn 

     

    The Title column of List2 does not have the same email address as the responder.

     

    Best Regard,

    Levi

  • kinghnvn Profile Picture
    kinghnvn on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi Levi,

    Output is empty, your advise please. Thanks.

     

    kinghnvn_0-1669867366271.png

     

  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi @kinghnvn   

     

    Please check the result returned by Filter array to see if the result is empty.

     

    Best Regards,

    Levi

  • kinghnvn Profile Picture
    kinghnvn on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi Levi,

     

    My flow ran successfully but the value not found in SharePoint list

    kinghnvn_1-1669866941308.png

     

    kinghnvn_0-1669866928986.png

     

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Add Responders' Email from MS form to SharePoint list and use lookup columns

    Hi @kinghnvn 

     

    Based on the screenshots you provided, I don't see a problem.
    Please tell me where your problem is so that I can help you better.

     

    Best Regards,

    Levi

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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard