Sending json pieces to a csv

Carla Murphy
Carla Murphy
Eighth Anniversary Kudos 1 Name Dropper Participant
in SKY Developer General Discussions

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?

Tagged:

Comments

  • Trevor Kelly
    Trevor Kelly
    Third Anniversary Kudos 1 Participant Facilitator 1

    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!

    f3258ee5af937e5750a71fa4b0e60589-huge-im
  • Carla Murphy
    Carla Murphy
    Eighth Anniversary Kudos 1 Name Dropper Participant

    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!

    61a719dce44474270fe824dca5b60411-huge-im
    da23158b320471d0685a1180fc324e84-huge-im
  • Edward Hohlbein
    Edward Hohlbein
    Tenth Anniversary Kudos 1 Name Dropper Participant


    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!

    f3258ee5af937e5750a71fa4b0e60589-huge-im

Categories