Answered

item()? Not Working in Select Flow

(0) Share

Report

Posted on by SweetPotatoSara

Hi,

I'm really at a loss right now. I've updated my table to include two new columns and a conditional column. I have a Power Automate flow to email a CSV with the following flow:

When I attempt to add the two new columns to the Select query using the item()?[''] logic, it doesn't switch the values into a dynamically mapped variable as it did before.

The csv has all the other columns with the data but these two new columns are only showing what I typed and not connecting to the data.

Why is the item()?[''] logic breaking here for these two columns? Am I missing something? Any help on this would be appreciated!

All responses (3)

Answers (1)

SweetPotatoSara 21 on at

Like (0)

Report

Re: item()? Not Working in Select Flow

Oh my goodness! I thought they removed that panel and had no idea that zooming out would bring it back. 😅 This is really good to know! Thank you so much for your help!
Verified answer

ArjunVMenon 28 on at

Like (1)

Report

Re: item()? Not Working in Select Flow

You've made a small mistake. Happens to the best of us!😊.
Item() is a power automate expression function and must be entered only inside the expressions panel. (PS: you may have to zoom out sometimes in order to see the dynamic/expressions panel)
creativeopinion 10,450 Super User 2025 Season 1 on at

Like (2)

Report

Re: item()? Not Working in Select Flow

@SweetPotatoSara You need to insert that expression as an expression. Right now you have it entered as a string of text.

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