Sharing my Power Automate Flow(s): Get Query Results as JSON

Ashley Moose · March 2025

While we already have the templates to get query results in a .CSV file, we can now get query results as JSON thanks to the updated Query connectors. After running this flow you can then use the JSON output for further manipulating and processing directly within Power Automate.

Attached you will find 4 different templates: 2 for RENXT, and 2 for FENXT. The ones noted with (gmail) include the gmail connector instead of the Outlook connector for email notifications.

Steps to update:

Update Initialize variable emailToNotify with the email address that should be used to notify of flow/query failures.
Update Start a query job to include the query you need to run.
Update the schema in Parse JSON query results.
- To update the schema you'll need to run the flow once.
- Click into the run history of that run and copy the output from Compose JSON results.
- Go back to Edit the Flow and on the Parse JSON action, click Use sample payload to generate schema.
- Then paste in the output copied above. Click Done.

Note: On 2/10/2026 something changed that causes another configuration step to be needed. See notes below from Austen Brown on 2/10 and 8:56 AM. I'll work on getting the .zip files updated, but until then, please follow Austen's notes!

GetRENXTqueryresultsasJSON_20250311145820.zip

GetRENXTqueryresultsasJSON(withgmail)_20250311145559.zip

GetFENXTqueryresultsasJSON_20250311145354.zip

GetFENXTqueryresultsasJSON(gmail)_20250311145314.zip

Greg Burton · March 2025

@Ashley Moose Thank you so much for this! I got this to work for me to have fundraiser notification emails be sent automatically when one of their assigned donors gives a gift (with link to donor record included). This will help them thank their donors much quicker.

Elizabeth Johnson · April 2025

@Ashley Moose, thanks for the Gmail versions!

Austen Brown · February 10

Adding in, as of this morning running the Body output from the HTTP action following the query call is causing errors.

To resolve the error, you need to remove the json() expression within the Parse JSON action to be only the dynamic output from the HTTP action above.

With the change, the flow runs as expected.

Ashley (can't tag you for some reason), you may want to update your templates to remove the json() expression from this step.

Ashley Moose · February 10

Thanks @Austen Brown. I just uncovered the same thing while working in one of my flows and was like "hmm" didn't I just see this in my Community email?? Not sure what changed. I'll aim to get the templates updated one of these days. Until then, noting above :)

Pollyanna Spears · July 13

Is there a way to add (logic) so the person receiving the email can click and the list opens up in REnxt?

Screenshot 2026-07-13 141731.png

Alex Wong · July 13

Since this is a Query, you can link to a saved query with the query id.

if you want a gift list, you will need to add additional flow action to create a new gift list with the specific gift system id identifier, then you can link to the gift list.

Pollyanna Spears · July 14

This is what I am doing currently. It creates the list of records from the query but I want to add a hyperlink for each line to the unified view of REnxt.

Erik Leaver · July 14

@Pollyanna Spears take a look at @Austen Brown 's tips for formatting tables. She has instructions on adding hyperlinks to notification tables!

https://community.blackbaud.com/discussion/59505/4-ways-to-spruce-up-your-notification-tables

Alex Wong · July 15

@Pollyanna Spears my misunderstanding, thought you want a link that take user to the gift list page that shows all the gift in the email.

if you simply want to link individual gift to a gift page, or individual constituent to the donor page, the link Erik provides will have the details you need.

Pollyanna Spears · July 20

Thank you both. Austen Brown solution is what I was looking for and now to try and make it work with my environment.

Sharing my Power Automate Flow(s): Get Query Results as JSON

Comments

Categories