web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : LXy2mJVEauTSGUf/RiDe/p
Power Automate - Building Flows
Answered

Create CSV table generating duplicate rows inside apply to each

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2023 22:19:26 by 19

In the flow, I am listing rows from a dataverse table, then for each row am running a few actions then taking the output of the specific row and creating a csv table for each row.  My problem is that inside the apply to each, when creating a csv table, the value option is returning all rows when i just want it to return the current item.  If I use body/value - item, in a compose it is showing the correct row I want to use, but changing the from in create csv table to body/value - item generates the error The 'from' property value in the 'table' action inputs is of type 'Object'. The value must be of type 'Array'.

 

How can I take the current item of the apply to each and create a unique csv table for the item?  

 

Thanks

 

Kthomas_0-1700086579592.pngKthomas_1-1700086657701.png

 

  • Kthomas Profile Picture
    19 on 16 Nov 2023 at 15:55:42
    Re: Create CSV table generating duplicate rows inside apply to each

    This was exactly what I needed.  Thank you!

  • Verified answer
    ManishSolanki Profile Picture
    15,085 Super User 2025 Season 2 on 16 Nov 2023 at 05:56:57
    Re: Create CSV table generating duplicate rows inside apply to each

    Hi @Kthomas 

     

    You could create an array of each row using expression. Expression needs to be entered in the expression box as shown below:

    ManishSolanki_0-1700113397778.png

    createArray(items('Apply_to_each'))

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2