Hello evryone,
I'm learning Flow, but this project is beyond my knowledge at the moment.
My ultimate goal is to insert a pie chart displaying how much cases have been handled ( HANDLED / NOT HANDLED ).
I have two Lists :
So, basically, what I want to do is pretty straightforward :
I didn't find a way to do this but to use Flow ( don't have Power BI license to insert a report, and Excel web-part is pretty awfull ).
However, I did find similar issues on the forum, but I'm not able to adapt the solution to my project.
Thank in advance for your help.
Solved! Go to Solution.
Hi @Ruben94 ,
Please try this:
Best Regards,
Hi @Ruben94
Try using SharePoint flow step trigger When an item is created or modified. Then check the handled value? Then use the Sharepoint Update item flow step to increment or decrement the list column value.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog
Hi @Ruben94 ,
Please try to configure your Flow according to the method mentioned in the similar posts in the forum.
The steps to create a Flow are simple. You only need to clarify the logic of the scene you want to implement and achieve it using the existing features in MS Flow.
It's hard to provide a detailed method for you based on your description. You could try to build your Flow based on similar methods in other posts.
If you have any questions when you configuring this Flow, you could post here so we can help you analyze the problem.
Best Regards,
Hey,
Thanks for your answers.
I tried and did a lot of research. I think I'm really close to my goal.
Here are my two lists.
As I said, I would like my TOTAUX List to reflect how many cases have treated ( integrated ) or not. So,
Here's the crucial part of my flow.
So there are 3 things I'm not sure about :
- The Filter Query. I don't know if that's the correct format. When I used the TRUE function, because the field is Boolean, ( "INTEGRATION eq TRUE ), it didn't work.
- I found the Get Items and Compose idea here. But, clearly, it doesn't work for me when I run a test. My output is the same as my input : @lenght(body('Get items')?['value']). I should get a number, should'nt I ?
- CATEGORIE from Update Item. It seems to work like that, but I wasn't sure what to type in.
Can you please help me ?
Hi @Ruben94
Thanks for the reply. What's your trigger here? Believe you can get the details from the trigger instead you using Get Items.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHere you go
So, ideally whenever someone modifies the DOSSIERS list, the TOTAUX list is refreshed to correctly reflects the sum of treated files and non-treated files.
Hi @Ruben94 ,
Please try this:
Best Regards,
User | Count |
---|---|
94 | |
47 | |
21 | |
19 | |
18 |
User | Count |
---|---|
137 | |
54 | |
42 | |
41 | |
30 |