Answered

How to get CurrentItem Value inside a For Each Loop

(0) Share

Report

Posted on by SamuelMDC1

So, I have a For Each Loop with the property "CurrentItem". CurrentItem returns sql columns format(Im using SQL queries within power automate desktop), with multiple fields. I want only one field from "CurrentItem", that is field "DSGrupo". How can i filter this within "Define Variable" action or inside "Execute SQL Query" Action?? I have tried creating a variable called "DescGrupo", and I have assigned this value to it: items()?['DS_Grupo']. The variable assign activity is inside for each, i also tried items(CurrentItem)?['DS_Grupo'].

In the "Execute SQL" action, I tried the following: SELECT * FROM dbo.Link WHERE DS_Grupo = "%DescGrupo%"

but it didnt work.

Prints below.

Any help is appreciated

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Try using %CurrentItem['DS_Grupo']%. This is the correct syntax to reference a column in a data row.

-------------------------------------------------------------------------

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SamuelMDC1

You have made one mistake, instead of item()?['DS_Grupo'] you have to use %CurrentItem['DS_Grupo']% in define variable.

Note that item()?['DS_Grupo'] is used in power automate cloud flow.

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No