Increment variable with conditions

(0) Share

Report

Posted on by PierreCA

364 Moderator

How to incremente a variable with a condition?

I already use the module.

The code to test the value and its possible responses.

if(equals(outputs('Obtenir_les_éléments_EvolutionStatutDemande')?['body/value'],'15'),0,1)

The condition doesn't work, but I'don't know why.

I've try with

if(equals(outputs('Obtenir_les_éléments_EvolutionStatutDemande')?['body/value']?['column_name'],'15'),0,1)

I'don't find real documentation on that use.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @PierreCA ,

Increment variable please use it with 'Apply to each' loop.

I did a test for your reference.

In my scenario:

My SharePoint:

Please make sure the selected column is a single line text column.

My Flow:

if(equals(items('Apply_to_each')?['ColumnName'],'15'),0,1)

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
PierreCA 364 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @v-yetonggu-msft ,

My actual flow has an additionnal step in the Apply to each function. The previous steps have been tested and they give the answer expected.

In Apply to Each, I create an array of values.

In the Apply to Each 2, I test one by one the values of the array against values contained in a second list. Then, I conditionnally increment the variable varSommeDemandesActives.

That's why I write my code that way, but it doesn't work:
if(equals(outputs('Obtenir_les_éléments_EvolutionStatutDemande')?['body/value']?['column_name'],'15'),0,1)
As the tested value is an ID number, I've try (with the real column name):
'column_name'
and
'column_name:ID'

Was this reply helpful? Yes No
Verified answer

PierreCA 364 Moderator on at

Like (1)

Report
Copy link

Link copied!
The solution is to explicitely point the line of data into the body of the result provided by Get Items function. As I try to compare a foreign ID in a SharePoint list, I must specify that point too.

The right line of code is the following:

if(equals(outputs('Obtenir_les_éléments_EvolutionStatutDemande')?['body']?['value'][0]?['FK_idStatutDemande_x003a_ID']?['Id'],15),0,1)

Source of inspiration: How to get a specific value from a JSON in Power Automate (tomriha.com)

Thanks for your help @v-yetonggu-msft . 🙂

Was this reply helpful? Yes No