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

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store