How to create a file using flow designer and save it in my Local machine

[Pooja Khatri]

Hello All ,

I have a requirement where I want to extract data from User table .. that data should be copied to one file and that file should be created using the flow designer once that data is copied to the file .. need to store that file in a local machine .

The entire functionality I need to implement it through Flow designer only .

Can anyone please help me with the implementation ?

[Ankur Bawiskar]

Hi,

then whose machine you want the file to be downloaded?

I didn't get your business requirement here

Based on the business requirement approach can be provided

Regards
Ankur

[Pooja Khatri]

Hi @Ankur Bawiskar -- See the Business requirement is as below : 

1) Trigger the flow

2) Identify the items fros sys_user table(which belongs to xyz region?)

3) Loop through the list of user items selected in step 2 and add them to the file

4) Create a file on local machine ( c drive) that contains these records .

All this step needs to be done through flow designer only.

[Ankur Bawiskar]

Hi,

Did the business team inform you to use flow?

Since they might not be knowing the feasibility of the requirement

Did you ask them a question whose local machine they are referring? Whether it's a mid server or any other machine

Please check on the questions with your team and share the updates

In other case I already provided the approach which you can propose to them

1) setup a mid server

2) use scheduled exports and export csv of user daily to mid server location

3) you can give filter condition as well which users to be pulled

Regards
Ankur

[Ankur Bawiskar]

@Pooja Khatri 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.