Ah we are using the "Select" action to reshape the results in a format that we need.

After filtering we get the data in this format

[

{

"@odata.etag": "",

"ItemInternalId": "0e8c8372-eeed-498c-bb25-ceb1168b430b",

"House number": "1",

"Street": "Street 1",

"City": "London",

"Painting": "Y",

"Gardening work": "",

"Plumbing": ""

},

{

"@odata.etag": "",

"ItemInternalId": "d52bb53e-6358-4d0b-85d2-bf0489d6e505",

"House number": "4",

"Street": "Street 4",

"City": "London",

"Painting": "Y",

"Gardening work": "",

"Plumbing": ""

}.....

]

and the "Map non empty values" (the Select action) loops through the filtered data and extracts "House number", "Street" and "City" from each item in the filtered data.

E.g. the purple token for "House number" is item()['House number'] - item being the current item (that is being looped by the Select action).

https://docs.microsoft.com/en-us/power-automate/data-operations#use-the-select-action

SharePoint developer at Content+Cloud.