Generate CSV out from Flow designer Action

[Kishore32]

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.

[Kishore32]

Pulling the user records, if the user is not logged in past 90 days then update some fields in the user table for the user record. So before updating the field in the user table business needs to see the list of users who were impacting for the update in the same workflow either by downloading the file to my local machine or some other way. But the report should be generated from the action that I created for filtering out the users based on the above condition.

Thanks,

[Ankur Bawiskar]

Hi,

you can use report for this and schedule it daily before running your schedule job script

Include the recipients so that they receive the list of users via email as email attachment

Regards
Ankur

[Hitoshi Ozawa]

Hi Kishore,

Is there any reason for viewing the users on the local computer instead of viewing the records on ServiceNow?

ServiceNow is able to list users that have not logged in past 90 days. A view can be created on user table with filter to just list those users. User records that needs to be updated can be checked in the list. The user record can then be updated based on the selection.

There is no need to create a flow with this approach. Just add a new check box field to the user table to indicate the record should be updated.