Sharepoint list and multiple value

(0) Share

Report

Posted on by Capuchino

Hello !
I have a problem with a flow only writing the first value from a sharepoint list

I have 3 lists:

When an item is created:

List 1

New number - Reference Number -

List 2

Reference number - Various values

I need to create the list 3:
New number - Reference Number - Various Value from list 2

When an item is created on list 1, the flow need to check the Reference Number equal to the reference number on list 1 and write down the reference number and all values on list 3.

My problem is that when updating item on my flow it's stop at the first value of reference number and doesn't check if there is other field with the same reference number after. Can you please help me ?

All responses (5)

Answers (1)

Capuchino 59 on at

Like (0)

Report

Re: Sharepoint list and multiple value

Hello @v-LilyW-msft

I have an other challenge in the app that I am building and I was wondering if you could help me again.

This time I have the list 1, with the column countries that have is a single line of text colum where the different contries are separated by a comma.

I would like to create the list 2 where each countries have a separate line

Do you have an idea on how to solve that one ?

Best regards!
Capuchino 59 on at

Like (0)

Report

Re: Sharepoint list and multiple value

@v-LilyW-msft Many thanks for your help it's working 🙂
Verified answer

v-LilyW-msft on at

Like (1)

Report

Re: Sharepoint list and multiple value

Hi @Capuchino
Thank you for a more detailed explanation.
You can take a try with the screenshots as below:
Assume list2 like this:
Flow in details:
About how to find column internal name you can refer to:
https://tomriha.com/what-is-sharepoint-column-internal-name-and-where-to-find-it/
When the new item is created in list1
The new items will be created in list3
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Capuchino 59 on at

Like (0)

Report

Re: Sharepoint list and multiple value

Hello @v-LilyW-msft

Many thanks for for helping me !
What you proposed is close to what I am looking for but not exactly.
Let me be a little more precise about what I have in mind:

The list 2 has some columns with different row for the same reference number .

For the list 3:
When an item is created on list 1, the flow need to check the Reference Number equal to the reference number on list 1 and write down the reference number and all related columns/values on list 3.
Do you have an idea of the solution ?

Many many thanks in advance for your help
v-LilyW-msft on at

Like (0)

Report

Re: Sharepoint list and multiple value

Hi @Capuchino
Could you please share me more details of data type in your list2 and list3?
Assume the following are my three lists. Do you want to create an item in list3 when the item is created in list1 as shown below?
If yes, you can refer to the screenshots as below:
When an new item created in list1, it will get the values of Various from list 2 and create a new item in list3.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.