Showing results for 
Search instead for 
Did you mean: 
New Member

Add a field from another list to my array

We have two lists in Sharepoint: One with members (including names, phonenumbers, email addresses and usernames) and one with some metadata on some of the members (specifically this is about an expiration date). We need a flow to send an email when the expiration date has passed. My flow will (1) get the data from both lists, (2) combine this information in a usable array, (3) loop through this array sending emails to every member with his/her information.


For now I have retrieved information from the metadata list and the members list. With the Select action, I create a new array with just the properties I need (MemberId, Name, Expiration date). I would now like to add a 4th column containing the email address, but I am unable to find a way to lookup the email by MemberId, in the members list data.


I've gotten as far as adding the extra column using the formula 


in the Select action. Of course, this gets me the wrong record since I'm using the ID to reference the row. (It also gets me the full record instead of just the email addres, but one thing at a time..) What I need is to replace this with some kind of lookup, but I can't find any function that does a normal lookup or find the way I'm used to in other platforms.


Hopefully someone can point me in the right direction.

Community Support
Community Support

Re: Add a field from another list to my array

Hi @BBD,


Could you provide more details of your two lists, is it that both lists contain a MemberId for unique identification?

I am curious how you created a new array with just the properties you need (MemberId, Name, Expiration date) with the select action.

I did a test on my side, because I want to use the Select action, so I used two Allow to each, and there is no what you said can not lookup the email, but because of the use of two Apply to each, the array contains duplicate elements.

Maybe your method is more subtle, could you share the details of the current Flow creation?

I would be helpful if you posted a screenshot of the configuration of your flow and we would provide a proper workaround for you.


Best Regards,


Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Super User Program Update

Three Super User rank tiers have been launched!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021


Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,915)