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

(0) Share

Report

Posted on by kinghnvn

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

My flow is below:

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.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

v-liwei-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

Hi Levi,

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

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @kinghnvn

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

Best Regards,

Levi

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

Hi Levi,
Output is empty, your advise please. Thanks.

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kinghnvn

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

Best Regard,

Levi

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @kinghnvn

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

Best Regards,

Levi

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

No Sir, it's showing the Title only

Was this reply helpful? Yes No
v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No