For some reason this trivial task took me about an hour to figure out today! Which sucks, especially coz this is something I have done a lot of times… but it’s been a while since I dabbled with Power Automate or Logic Apps, so I forgot. Plus I never blogged about it in the past coz it was pretty straight forward.
Anyways. I have a Power Automate that reads from an Azure Table. The result is an array with each entry having many properties. I am interested in just one of them, so want to create an array out of that property. Simple.
Here’s how to do this:
After the step where I get the entities, I must add a select action. This is typically used to rename or modify keys & values. And this is what it looks like by default:
The trick is to click the “T” icon on the right, and then you can enter just the property you want. Like item()?['UserPrincipalName'] in my case.
(The error goes away after I add the expression).
In my case I then wanted to put this into a string, so I also did this in a next step to combine the array into a string:join(outputs('Select')?['body'], ',')