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.
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.
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.
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 ?
Here 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.