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

Ashley Moose

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:

1. Update Initialize variable emailToNotify with the email address that should be used to notify of flow/query failures.
2. Update Start a query job to include the query you need to run.
3. 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.

GetRENXTqueryresultsasJSON_20250311145820.zip

GetRENXTqueryresultsasJSON(withgmail)_20250311145559.zip

GetFENXTqueryresultsasJSON_20250311145354.zip

GetFENXTqueryresultsasJSON(gmail)_20250311145314.zip

Greg Burton

@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

@Ashley Moose, thanks for the Gmail versions!