Opportunity Custom Fields System Record ID?

Catie Wools
Catie Wools
Kudos 1 Name Dropper Participant First Anniversary
in Blackbaud Raiser's Edge NXT® APIs

Hey Yall! Apologies if this should go into a different community, but I am trying to get a Power Automate flow to send an email listing the comments of an opportunity attribute. I have an idea of what I want to do, I just have one issue: I have no clue where to find the system record ID of the attribute! I've tried all of the normal places to find the record ID, but I can't find anything. Any tips?

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge

    @Catie Wools
    why do you need the opportunity custom fields system record id?

    with opportunity system record id, you can get list of custom fields for that opportunity, and then email the comments.

  • Catie Wools
    Catie Wools
    Kudos 1 Name Dropper Participant First Anniversary

    @Alex Wong We use custom fields to record any changes on an opportunity (i.e., Going from Cultivation to Solicitation would get a Stage Change custom field of Stage Change: “Cultivation”, etc.) so each opportunity (depending on how old it is) can have upwards of 10 attributes each. I'm looking to only pull a specific field that we use to document increases in the expected amount to put into a table alongside other information about the opportunity (Name, Fundraiser, Fund, etc.)

    My goal is to use the custom field system record ID in a condition on Power Automate that would filter out all of the other fields and only return that attribute. (So, it would be a Condition with the expression of [Category] [is equal to] [RecordID])

    Edit: Forgot to add, I'm pulling the custom fields using the List Opportunity Custom Fields option and pulling the Opp. System Record ID from the Get an Opportunity option

  • Dan Snyder
    Dan Snyder Community All-Star
    Tenth Anniversary Kudos 5 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge First Reply

    @Catie Wools I think what might be a simpler approach would be to use the Filter Array action. Then you could filter the array of custom fields that are pulled to just the category for the amount increases.

  • Catie Wools
    Catie Wools
    Kudos 1 Name Dropper Participant First Anniversary

    @Dan Snyder I completely forgot about that action! That would work perfectly, thank you so much for the idea!!!

Categories