Hello,
I created a Flow within a Power BI report that populates a .csv table based on projects selected in the Power BI report, then it sends the .csv in an email.
I would like to count the number of rows in the .csv table and create a condition to send only if the number of rows selected are less than 5.
Can anyone guide me on how to arrive at the row count in the .csv table that's created? From there, I can apply a condition.
Solved! Go to Solution.
Hi @bchager6
I can see you already using an array for creating the CSV file. You could try the length() expression, pass the parameter as the array.
If that doesn't work follow the below steps.
Above under the EnterKey variable press the keyboard enterkey as the default value.
Above expression I used is as follows:
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @bchager6
I can see you already using an array for creating the CSV file. You could try the length() expression, pass the parameter as the array.
If that doesn't work follow the below steps.
Above under the EnterKey variable press the keyboard enterkey as the default value.
Above expression I used is as follows:
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThis worked. Thank you!
User | Count |
---|---|
89 | |
41 | |
23 | |
20 | |
16 |
User | Count |
---|---|
130 | |
51 | |
48 | |
36 | |
26 |