Sending json pieces to a csv

Carla Murphy

I have a flow that is getting multiple json results, constituent, latest gift, email, etc, and want to send the json pieces to an excel or csv file.

Does anyone know how to do that?

Trevor Kelly

Hi Carla! You can use the Create CSV table action in Power Automate, and then use either Sharepoint or OneDrive to save that csv file. Here's an example screenshot of what it might look like. Let me know if this helps!

Carla Murphy

Hi Trevor! I am able to send the pieces of the constituent json output to my excel table. Now I want to add latest gift amount and date, so I added a Get Constituent latest gift to the flow.

I tried to union the arrays in the select an output from previous step. I think I need the latest gift json output to my schema maybe? Thanks!

Edward Hohlbein

This is GREAT, @Trevor Kelly ! Was trying to do this on my own. Should have checked here first. ?

Trevor Kelly:

Hi Carla! You can use the Create CSV table action in Power Automate, and then use either Sharepoint or OneDrive to save that csv file. Here's an example screenshot of what it might look like. Let me know if this helps!