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!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

creativeopinion 10,508 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

@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
Verified answer

ArjunVMenon 28 on at

Like
a
(1)

Report
Copy link

Link copied!

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)
SweetPotatoSara 21 on at

Like
a
(0)

Report
Copy link

Link copied!

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!