Problem with Select from Array

[Smolar]

Background:

So I made up a workflow (one of many) which in general getting data from SP list (filtered upfront, no issues here), assigning results to an array. Then I want to Select 2 columns out of it.

Problem:

Here where the problem starts - even though, after checking the outputs and verifying everything is there as it should, flow still throws an error, that some column does not exist.

ErrorMsg

Output Array

As you can see at the bottom, column called EMAIL_PREPARER is there but error message states, that is not. Can you please somehow guide what is wrong there? Below added just how my select query looks like. Values are item()[Field1] & item()['EMAIL_PREPARER']

Many thanks for any help and advice. Cheers.

[creativeopinion]

@Smolar Please share a full screenshot of the flow to provide more insights. From the screenshots that you have shared, the dynamic content labels you have selected for the values in your Select action look incorrect. However, by sharing a full screenshot of the flow I can see how you've structured your flow and provide recommendations.

In the meantime, you might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this tutorial I cover:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

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! If you're feeling generous— ☕️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok