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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Combine an inde...
Power Automate
Answered

How to Combine an index column and a select array

(0) ShareShare
ReportReport
Posted on by 19

Hey all,

 

I have a flow which creates an array using the range function to use as an index

 

npinot2002_0-1708531386547.png

I put it in a select statement, and now I want to add it as a column to another select statement derived from Power BI Data

npinot2002_2-1708531597388.png

 

I'd prefer a solution that does not use Apply to Each. Here's how I want the data to be formatted

 

Power BI Data 1Power BI Data 2Power BI Data 3New Row
---1
Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @npinot2002 

    According to your description, you want to add an index column from your output of the "Run a query against a dataset", this is my test data and the end result in the "Select" action:

    vyueyunmsft_0-1708580877544.png

    And this is my test flow:

    vyueyunmsft_1-1708581018549.png

    outputs('Run_a_query_against_a_dataset')?['body/firstTableRows']?[item()]?['PowerBIData[Title]']
    outputs('Run_a_query_against_a_dataset')?['body/firstTableRows']?[item()]?['PowerBIData[Country]']
    outputs('Run_a_query_against_a_dataset')?['body/firstTableRows']?[item()]?['PowerBIData[Cost]']

    item()

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard