Announcements
25
I'm trying to build a flow that extracts values from a excel cel that's the bases for a Prompt in a PowerBI paginated report.
In excel the column CustomerNumber holds values like:
To handle the MULTIPLE value prompt in PowerBI Report Builder
The output should be:
Share
Report[
{
"name": "CustomerNbr",
"value": "1050"
},
{
"name": "CustomerNbr",
"value": "1051"
},
]
How to achieve this in Power Automate?
Yes! this did the trick!
Report is now working and exports an excel ...and also for MULTIPLE prompt values like specified in the printscreen at the start of this topic.
many many thanks @efialttes I will mark it as 'solution'
@Bob1212 I do not have 'Power BI' license so I cannot use the connector, but from the screenshot you shared I would suggest you the following:
Click on the 'square with a T inside' icon on the top right corner, delete whatever value you see filled inside this input and assign 'Select' action block output to it, so it should look like the following:
Hope this helps
@Bob1212 On your Flow editor, please expand the Select action block and share a screenshot, please also type any possible WDL expression you are currently using as input
Thanx!
The body() function results in an error at the PowerBI Prompt action.
The reason it's now somehow nested in the default set-up of this activity:
See the red box... I need the green one
Hi!
I believe WDL expression referencing your Select output is:
All responses (
Answers (
body('Select_CustomerNbr_Prompt')Please note in every iteration of your loop the output is of type array, with one element of type object, as per the example you provided
Hope this helps
Hi @efialttes ,
That worked! I can now see the flow is giving me back the results of the prompt values like desired.
But how can I pass them to the next step: Export To File for Paginated Reports?
in that 'Action' there is a field where the result should be populated... But I can't seem to figure out how to pick the results in our 'Select' action...
Hi again!
The first problem is, since you are adding Select inside an 'apply to each', you need to reference the current row processed with WDL expression item(). In your case, you wanna evaluate column CustomerNumber, this means you need to reference it by means of item()?['CustomerNumber']. So your split() based function should be as follows:
split(item()?['CustomerNumber'],';')
Now I have this test table...
and I've executed the following flow successfully (3 rows, 3 'Apply to each' iterations). Even if the third row does not have any value assined to column 'customer Number' the test flow does not crash.
If you need such rows to be removed from the execution you can use a Filter Array action block before the 'Apply to each'.
Hope this helps
Hi
Thanks for your quick reply.
I've added your Select step in my flow:
But it immediately errors (see below)
The Split() function syntax:
split(outputs('List_rows_present_in_a_table')?['CustomerNumber'],';')
is this correct??
The Item() function is kept blank
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
