You’re offline. This is a read only version of the page.
Announcements
19
Hey all,
I have a flow which creates an array using the range function to use as an index
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
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 1 | Power BI Data 2 | Power BI Data 3 | New Row |
| - | - | - | 1 |
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:
And this is my test flow:
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
Share
Report
All responses (
Answers (
