Seek Help : Not able to Create File on Sharepoint having content of all data in CSV Table

[Anonymous]

Hello Community,

I need your help please.

Flow:

Main Image

Sequence :

1. List Plans for a Group. ( 9 Plans are fetched for a given group "X")

2. List Buckets for each of the Plans listed as part of Step 1. ( Count of Bucket is different for each of the above Plans, and is fetched). It can be seen by selecting/navigating to each of 9 Plans as shown in  below image 1.

Image 1

3. However, when I execute Create File (Sharepoint), only the Buckets List for 9th Plan is written in defined  dd.csv.

Desired Output:

The File dd.csv should have entries for all the 9 plans, not just 1 plan.

Below is the csv o/p with entry only for last (9th Plan).

@odata.etag	name	planId	orderHint	id
W****"	T****o	z****o	8****s	4****u

Expected:

@odata.etag	name	planId	orderHint	id
x	Bucket 1.1	Plan1	x	x
x	Bucket 1.2	Plan1	x	x
x	Bucket 1.3	Plan1	x	x
x	Bucket 2.1	Plan2	x	x
x	Bucket 3.1	Plan3	x	x
x	Bucket 3.2	Plan3	x	x
:	:	:	:	:
W****"	T****o	z****o	8****s	4****u

Thanks & Regards,
AGR

[efialttes]

Hi!
The problem is, you are iterating over all your buckets, in each iteration you are creating a file called dd.csv... meaning each time you iterate you overwrite the previous dd.csv

I guess you expect 9 files to be created right?
If so, I would add bucket id to the csv file name, since this id is unique.

Hope this makes sense

[Anonymous]

Hi @efialttes ,

No, I want a single csv file having o/p of all 9 iterations, split by row.

PS:

Below is the csv o/p with entry only for last (9th Plan).

@odata.etag	name	planId	orderHint	id
W****"	T****o	z****o	8****s	4****u

Expected:

@odata.etag	name	planId	orderHint	id
x	Bucket 1.1	Plan1	x	x
x	Bucket 1.2	Plan1	x	x
x	Bucket 1.3	Plan1	x	x
x	Bucket 2.1	Plan2	x	x
x	Bucket 3.1	Plan3	x	x
x	Bucket 3.2	Plan3	x	x
:	:	:	:	:
W****"	T****o	z****o	8****s	4****u

[efialttes]

Hi again!
Then you probably need to initialize string variable, then store csv output from each iteration inside by means of an 'append to string variable' to be added inside your apply to each. Please note you will probably need to adapt the csv output before appending it.
Finally, you need to move 'Create file' outside the 'Apply to each', assign as its input the string variable
Hope this makes sense

[efialttes]

Hi again!
I am just thinking on a simpler faster approach, that is to use the 'Apply to each' to append 'List buckets' outputs to an array varuable by means of a union() based expression.
Then move 'create csv table' out of the 'Apply to each'
Hope this helps

[Anonymous]

Thanks @efialttes , I'll try both now. 

Meanwhile, can you please help guide more on usage of Union operator here (with a few image), I am a rookie in flow and have used only dynamic expressions for now. I'll explore, still, a way like above can help me quickly.

Thanks Again 🙂

[efialttes · Accepted solution]

Hi again!

Create CSV out of the 'Apply to Each' approach. I just have one Plan defined in my test bed, need your help to verify this approach works with more than one:

Hope this helps

[Anonymous · Accepted solution]

Hi @efialttes ,

I followed below approach to get rid of it. Took some modifications of having added variables for it to be aligned properly while converting to csv, but in short, "Appending Array Variable" seems help resolve the case.

Thanks for your help, I'll execute your last recommendation and update shortly. Courtesy you, I could explore the possibility of using expressions. Thanks again.

[efialttes]

@Anonymous 

I see you are building your own CSV. Great idea, good job!

As you can see, challenges can be overcome by means of different approaches, all of them with pros and cons.

Thanx for posting your progress here!