web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create a CSV form exce...

Power Automate

Unanswered

Create a CSV form excel , with the last row and delete data excel

(0) Share

Report

Report

Posted on by casperna

8

Hi everybody

I need your help about my onboarding process, my last step is to create a CSV file who wil be use by a powershell script to create AD account

I fill a excel file, list row present, the CSV is created : no problem

But the CSV file take all rows, so if i have 2 rows, there will have the 2 rows data into the CSV and 2 account created

so i try to put a Compose with this setting :

- last(outputs('List_rows_present_in_a_table')?['body/value'])

or with : last(outputs('List_rows_present_in_a_table')?['body'])

the csv take always all rows and not the last

An another solution, could be to create only one row and delete this row after csv processing

but i dont find how do that

Pa : Pwer automate flow

pa1 : the ocmpose

pa3 : excel source to create the csv

thanks for you help

Categories:

pa.jpg

pa1.jpg

pa3.png

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @casperna,

Have you tried using that expression in the From field of the Create CSV action instead of the Compose?

Try something like below.

I have added the square brackets to convert the one object into an array with one object.

[@{last(outputs('List_rows_present_in_a_table')?['body/value'])}]

Was this reply helpful? Yes No
casperna 8 on at

Like (0)

Report

Hi Expicornovus

Great work ! thats work fine ,just with" [ ]" just incredible
so many thanks for you help

A last question , this weekend i found a another solution without "Compose" i have the same results
in "list row in a table" , i fill Top count to 1
but i dont understand why thats works,
So i prefer our solution with the compose and Function Last

Thanks for your help

pa.jpg

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @casperna,

The Compose is not really needed. It just uses the same data as the expression and shows it in a compose.

However, if you want keep using it you can use the setup like below where you use the outputs of the Compose instead.

Was this reply helpful? Yes No
casperna 8 on at

Like (0)

Report

Thank you for the information
Have a nice day

Was this reply helpful? Yes No

Join the conversation