Sending individual Excel files from SharePoint to Individual Contact email addressed from Specific Cons Record

@Christine Prete
I don't really see a need for more than 1 flow to do this, even the create attachment part.

First of all, I don't think the “fund relationship" matters here (at least from what your post say).

• If you know specifically the 25 constituent records and always the same, then have a array variable with the 25 constituent records system id
  • Better option for more dynamic-ness is to have a “tag” on the constituent that can be used in filter for list constituent API call, either constituent code or constituent custom fields
• then loop through the list of 25 constituent records
  • if you use a static array variable, you will need to call “get constituent” using the system id to get info on the constituent, otherwise, no need as the list constituent will retrieve info of constituent
  • create the attachment for the constituent in loop
  • save the attachment in sharepoint
  • compose email
    • send to the primary email in constituent record
    • subject and body however you want it, with “varying” info using conditional expression in the body or use string variable
    • attach the file that was created inside the loop (depending on how you created the file, you may need to call “get file” from the sharepoint connector to get file content to use in the email.

@Christine Prete
This isn't too hard to resolve:

I know there is a constituent relationship API call, so maybe from there you get “fund relationship”, not sure

or

you can still do the same thing as you do with flow 1 right now, but instead, take what you do in flow 1, do it inside the apply to each constituent loop. How you do this, depends on how your flow 1 currently “gather” the gifts to put in excel.