Hi,
A huge thank you to everyone who posts and provides solutions in this community - it has assisted me in learning how to build flows immensely.
I am now a little stuck so I am posting on here - crossing my fingers for some assistance!
This is what I am wanting the flow to do:
I believe my flow so far works correctly in obtaining the last month's data using a filter query.
The trouble I am having is that the filter array does not correctly add the values - it seems to add every row of data returned for these dates instead of the values. I also have not found a way to display the last month name, only this months I have tried different options for flows for a few days scratching my head, using string variables instead of an array, parse json with no luck. I thought I better stop wasting time and see if anyone has any ideas!
My current flow is as follows:
The length expressions in "Compose" both link back to each separate array eg:
This is a screenshot for reference of the "Incoming Offers list" multi choice format column I am trying to add up the selected choices, and the next is the "Incoming Offers Stats" list I am wanting to place the counts in for the month:
Thank you!
Solved! Go to Solution.
Hi @roxy1,
I think the challenge is that you are looping through list items and from those list items you want to loop through format choice items. Nested arrays, always fun 😁
I would use a select within both the apply to each loops and use the format collection in the from field of that select. Only use the value field of that array in the select:
item()?['Value']
This way you only need to look at the item() in your filter array actions.
Below is a screenshot of that approach.
Btw, in that example I am also using an increment variable action to keep track of the count. That variable is using the same length function like you were using before.
Hi @roxy1,
I think the challenge is that you are looping through list items and from those list items you want to loop through format choice items. Nested arrays, always fun 😁
I would use a select within both the apply to each loops and use the format collection in the from field of that select. Only use the value field of that array in the select:
item()?['Value']
This way you only need to look at the item() in your filter array actions.
Below is a screenshot of that approach.
Btw, in that example I am also using an increment variable action to keep track of the count. That variable is using the same length function like you were using before.
Thank you so much for your time in creating this and answering. You've saved me weeks of trying to figure it out!
For anyone else who reads this post for the solution, don't forget to initialise the integer variables in your flow so you can give them their value in the above solution step 🙂
I also used individual "compose" for each format total as they needed to be put in separate columns in the new share point list.
Thanks again!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
24 | |
18 | |
16 | |
13 |
User | Count |
---|---|
134 | |
43 | |
32 | |
32 | |
29 |