I have seen a couple of different options - but what is the most efficient way to add the Fundraiser Name to a Constituent List in Power Automate?
@Reuben SchmitzAs SKY API support for getting “fundraiser” is still limited to per constituent, it's not best way to create list with.
Query API is likely your best bet to get ALL data saved somewhere then picked up for Power BI
@Reuben Schmitz- Hi Reuben, are you asking how people pull in the fundraiser when they are using Power Automate into let's say a Gift Detail or did Alex answer your question as far as it can only be pulled per person?
I can share a screenshot of how I pull in a Fundraiser for a person who gave a gift if you are looking for that.
-Carol
@Alex Wong follow-up question - what would I do to have each Custom Field display as a separate line - this is how it is coming through now:
@Reuben SchmitzOh wait… I think you were doing populate word doc… you have to make the text control field multi line
@Alex WongThanks again - thought it was something simple. All set. Appreciate your sharing your expertise with me (and the group).