Update a Sharepoint item when another list is modified

[Ruben94]

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 :

1. CASES List : contains the name of every case and either it has been handled or not ( NAME = TEXT / HANDLED = YES/NO )
2. TOTAL List :  it's the one the chart is based on. Contains the total of handled cases, and non-handled cases ( STATUS= TEXT / TOTAL = NUMBER )

So, basically, what I want to do is pretty straightforward :

• When a case is HANDLED ( NO to YES ), increment by 1 the TOTAL of HANDLED cases in the TOTAL List and decrement by 1 the TOTAL of NON-HANDLED cases.
• Exact opposite when a HANDLED case is revert to NON-HANDLED ( = NO )

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.

[abm]

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.

[v-bacao-msft]

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,

[Ruben94]

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 ?

[abm]

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.

[Ruben94]

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.

[v-bacao-msft · Accepted solution]

Hi @Ruben94 ,

Please try this:

Best Regards,