I have created .csv file in logic app each time when the flow runs the data must be append to the same .csv

Question

I have created .csv file in logic app each time when the flow runs the data must be append to the same .csv

Ananya Dixith 61

Hi, I have created .csv file in logic app, but each time when new item is added it is creating different excel. I need all the data must to append in single excel. for every each run new items will be added, but each time it is creating new .csv We need each time when the item is created it should add in to same excel. Pls let me know whether it is possible to append data to same excel. Kindly help me to solve this csv action

Screenshot 2024-02-27 130446

Accepted answer

1 additional answer

Your answer

Answer 1

MikeUrnun 9,777 Moderator

Hello @Ananya Dixith - Thanks for reaching out, and engaging the MS Q&A community.

For appending to an existing blob file that's in a .csv format, you can do the following:

Remove the "Create blob" action.
Initialize a new variable of type string
Add "Get blob content using path (V2)" action to fetch the existing .csv content
Store the existing content of .csv file to the new variable
Add "Update blob (V2)" action where its "blob content" parameter will use concat() function to append the new content to the existing content. Alternatively, you may also consider using the "Append to variable" too.

I hope the steps and their corresponding links will help accomplish the task. If you encounter any issues along the way, Feel free to tag me in the comments below.

Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.

Ananya Dixith 61 Reputation points

2024-03-07T03:44:51.5833333+00:00

Hi Thank you so much for your reply.

Its helpful

But the problem I'm facing is , when the logic app runs for the first time the data whatever is receiving it should create .csv file automatically, hence I have added create blob action for .csv

then when the logic app runs for the second time , the data which is receiving in the second run it should get append to the same .csv file which has been already created during first logic app run.

If I delete the create blob action in the flow then the data which is receiving through the first logic app run cannot be able to create .csv blob in container..

Pls help me with this if possible, at first when data received it should create .csv file,

second time when data is received it should update the same .csv file which is created in previous run for the first time.

Pls help me out with this
MikeUrnun 9,777 Reputation points Moderator

2024-03-12T05:32:14.47+00:00

@Ananya Dixith That should be easily accomplished as well. Logically speaking, you'll first need to check the existence of the .csv file, and: if true, take the steps listed in my answer above, if false, then create a new file with "Create Blob" action. You can implement this logic using the Conditional feature in Logic Apps, take a look at the following doc: Add conditions to control workflow actions in Azure Logic Apps
Ananya Dixith 61 Reputation points

2024-03-12T10:16:56.1333333+00:00
Hi @MikeUrnun

I have used condition to check whether .csv blob is present or not.

In order to check first I have used list blob action to get whether the container is empty or not

If the container is empty or if there is no .csv file then .csv blob must be created.

In order to get that I have used list blob action at first.

and then I have used condition to check

whether blob is present or its empty

If present it is of .csv file or not, hence I have used below condition but it is giving output has not specified.

Can you pls help us to know what should be given for condition

Thank you
MikeUrnun 9,777 Reputation points Moderator

2024-03-26T17:49:51.7466667+00:00

Ananya Dixith You should definitely use the "List Blobs" action but it'll take a bit more work. You'll want to initialize a new variable of type array and then iterate through the list of files "List Blobs" action returns by using the Foreach loop. In each iteration, you'll want to extract the filename and populate them into the initialized array. Once you have array of strings (that are filenames of existing files), you can then check the presence of the csv file by using contains() function within your IF condition.

Answer 2

Hi,

At first use list blobs, to get the files in the container

then add the condition to check whether container is empty or not.

User's image

If length of the body is equal to zero then the container is empty , it should create new .csv file

User's image

If it is empty then it goes to TRUE condition

1.Create new array variable("newdata") for new data and append to it

2.create CSV table

3.create .csv file in container

User's image

If the file is already present in the container then false condition,

At first it should get data present in existing .csv file.
Convert .csv file to JSON format
Append the existing data to new array variable.
In compose action join new data("newdata" array variable) and existing ("existingdata" array variable) using "Union"
Create CSV table
Update blob

Share via

I have created .csv file in logic app each time when the flow runs the data must be append to the same .csv

1 additional answer

Your answer