Generate CSV out from Flow designer Action

Kishore32
Tera Contributor

Hello,

I'm having a Flow that fetch records using 'Loop up records' based on some condition and if condition satisfies then have to update the record.

Before updating the record I would like to generate a CSV file from the 'Look up records' to ensure the data is correct.

Is there any way that we can generate a report out of Flow action? any other suggestions?

Thanks,

Kishore.

12 REPLIES 12

Hi,

sharing link here for sample script; enhance it

Generate CSV file through script

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thanks for the response!!

I've followed the link and able to generate an expected result in attachment but I wanted to move the result to some file in my local machine, is it doable? any suggestions.

Thanks

which local machine?

you would require to have mid server installed on that machine and then you can think of transferring

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

To my local workstation machine. Can I download it? if not please go over below items

I'm looking 2 more other options, throw me some light on below options

1. Save the CSV file to somewhere in servicenow instead of attaching to a record.

2. I can send that attachment through the email action in flow?

suggestions please.

Thanks,

 

Hi,

what's your business requirement?

If you wish to store it to your local machine you need to add the file as attachment and then click it to download

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader