Power Platform Community Forum Thread Details

I have this flow which updates my Sharepoint List when somone updates their Appointment in Bookings. The get items always returns "value": [] even if the Filter should be correct. I would really appreciate the help.

The Flow:

Filter Query:

An Example:

Filter query of get items:

Value in Lists:

Output:

Best Regards

Categories:

Building flows

@Huerter Can you try running your flow in the Classic Designer? The new designer is still buggy. If that doesn't work, can you confirm the internal column name of your column didn't change?

Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list. If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.

Also, I'm assuming you will only return a single item from your SP list. If this is the case, the Apply to Each (for each loop) action isn't necessary. Power Automate will automatically add this loop to your flow because the Get Items action will always return an array of items (even if it's a single item) you can avoid the loop with an expression. Check out the tutorial I've linked below.

3 Mistakes YOU 🫵 are Making with the Apply to Each Action in your Microsoft Power Automate Flow

In this video tutorial I’ll go over how to avoid these common mistakes when using the Apply to Each action in a Power Automate flow:

1️⃣ Looping through a Single Item

2️⃣ Creating Unnecessary Nested Loops

3️⃣ Looping through an Unfiltered Array

At the end of the video I share a few helpful insights when it comes to using the Apply to Each action in your flow.

IN THIS VIDEO:

✅ How to avoid the Apply to Each action with a single item array

✅ How to use the item() function to access dynamic content in an array

✅ How to prevent unnecessary nested Apply to Each action loops

✅ How to use the Select action

✅ How to convert an array to a string with the Select action

✅How to use the Filter Query field

✅ How to count the number of items in an array

✅ How to use a condition control

✅ How to use the concurrency control

✅ How to set a top count

✅ How to use Compose actions for troubleshooting

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram