Power automate gifts and opportunities

Ashley Gelderblom

Hello, can anyone help with which power automate api to use to get the opportunity id that is linked to a gift, I can do it looking at opportunities, but I need to be able to lookup a by gift id then get the opportunity id that is linked to it

Alex Wong

I don't believe what you want exists as an API.

As you are aware, you can get the linked gift from the Opportunity side, not from the gift side. So the only option for now is to get all the opportunity, and take the linked_gifts properties (which is an array as more than 1 gift can be linked to an Opportunity), and store that into an excel, sharepoint list, or data warehouse then perform a search on the gift system id from there.

Another option if you don't have a ton (more than a few thousands) of Opportunity is to use Get Opportunity List API, then in power automate use the Filter Array on the list of Opportunity returned, and use an advance filtering:

@contains(item()?['linked_gifts'], '12345')

12345 is the gift system record id

Ashley Gelderblom

ooh i like that second option- thanks I am going to use that