0

I have two SharePoint lists: List A and List B.

Both lists have a column with a special number called VHE (text column) and a column Date.

The Date column in List B is still empty and I would like to fill it with the values of the Date column in list A, if the VHE numbers in both lists match.

I started a flow in which I 'Get items' from both lists. And then added a condition that If VHE number in list A is equal to VHE number in list B, the Date Column from List B is updated.

But that does not work. What am I doing wrong?

enter image description here

1
  • Are you seeing any error after flow runs? Both columns have same data type (text) in both lists? Commented Aug 10, 2021 at 16:05

1 Answer 1

0

In my testing, I cannot reproduce your problem. Are there any error messages when you are testing and running the flow?

My Test:

1.I have two lists in the same site.

  • ListA: Testb

enter image description here

  • ListB: Copy_Testb

enter image description here

2.Create Microsoft Flow

enter image description here

3.Save and Test this Flow

It is worth noting that since you choose "Manually trigger a flow" Trigger, you need to trigger the flow manually.

enter image description here

enter image description here

========================== Updated Answer =========================

According to my research, because there are more than 5,000 items in your list. Therefore, I suggest that you can set Filter Query in "Get items" action to make the number of obtained items less than the threshold of 5,000.

Reference:

6
  • Hi I tried this, but i get a Time-out error when running the flow. List B has over over 7.000 items. Commented Aug 11, 2021 at 13:02
  • Hi Mirjam Kaal. Regardless of the Power Automate license, the "Get Items" Action limitation is 5000 items. This is a limit of the SharePoint REST API, and not Power Automate. Reference: powerusers.microsoft.com/t5/General-Power-Automate/… Commented Aug 12, 2021 at 8:03
  • Aha, but is there another way to get the same result? Commented Aug 12, 2021 at 11:50
  • Hi Mirjam Kaal. I have updated answer under initial My Answer. Hope this can help you to solve issue. Have a nice day! Commented Aug 16, 2021 at 6:34
  • so far, the flow is succesfull. However the items are not changed. So i am doing something wrong. I will try again this afternoon. Commented Aug 17, 2021 at 7:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.