for each elements in sharepoint list

(1) Share

Report

Posted on by diegomarino

128

Hi,

i want to loop through elements in a sharepoint list, but "getitemresponse" is not a table value.
How can i break every records? and get a field value?

I'm using the FX preview

THanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (0)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

Hi there,

Could you please share your flow screenshot to understand your issues in depth and assist on this?

Thanks,

Deenu

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

If you want to go through Sharepoint list you need to use "Get items" -action to get all the items in the sharepoint list. Then in For each loop you put =GetItemsResponse.value

And then the loop goes through each row in that sharepointlist. If you want to get certain column value from that currently looped row then use =CurrentItem.ColumnName (in my example its field_4)

The currentItem should show the column names when you open its attributes.

Flow example:

Or if you want just one item without looping through the list then you can use Get item instead of Get items

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

thanks both, it was actually easy but i'm new to PAD

I tried to find some documentation to learn more, can you give me some useful link?

Then, the field i need has some simple HTML tags, that are rendered in sharepoint, i need to fill a textbox in a site, do i need to do something to render the html format?

Was this reply helpful? Yes No
eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Happy to hear it helped! Yeah unfortunately documentations on many actions are often incomplete or missing entirely.

About your second question can you explain a little further? How does the HTML tags look like when you retrieve them in PAD? what would be example of an outcome?
Does it return like this abcValue and you want the abcValue? Or do you also want it to be bold or whatever the tag is rendering the text as? If you also want it to be for example bolded if the tag is then first thing is to make sure the textbox supports HTML rendering.

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

hi, yes i'm speaking about and stuff like that, but i think that the Power automate pop up message cannot handle it, so i think i'll have no problem when i use the text properly

However, i'm struggling with another problem. As you can see i want to confront two variable, but i cannot get the correct syntax

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

In Power Fx always add equal sign in the beginning.

So to check if variable1 is same as variable2: =variable1=variable2

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

thanks. It's a very strange language thou...

Was this reply helpful? Yes No
diegomarino 128 on at

Like (0)

Report

hi, sorrry to come back, but i made the flow and i get the html tags problem

I get:

Gent Dott. , <div>non avendo avuto il piacere di sentirla mi permetto di disturbarla ancora visto che ho di molto ampliato il panel dei miei clienti e ricerco figure da inserire in un percorso di crescita. Se vuole possiamo sentirci per un approfondimento, altrimenti le do un grande in bocca al lupo.</div> Grazie dell'attenzione 

clearly the system do not render the html tags, the text is shown properly in sharepoint, i take it from sharepoint itself and put it in a website textbox.
How can i render the html instead of the characters? i tried encodeHTML function but it's not good

Was this reply helpful? Yes No