Condition is not working, it is always false... (Microsoft Forms to SharePoint item)

[ahmadbutt]

- Without the condition the Flow creates a SharePoint item from Microsoft Forms. So this part works good.

- The condition; id-test(Microsoft ID) is the same as Id-test(SharePoint item) does't work, see condition.

Someone got a idea to let it work?

[Jay-Encodian]

Hey @v-litu-msft 

Would that not error if the array was null as the length expression expects a value?

You could use the empty() expression instead?

HTH

Jay

[ahmadbutt]

@Jay-Encodian This also gives the same error.

- false = working = creating a item.

- true = not working...

[Jay-Encodian]

@ahmadbutt 

What does not working mean? what;s happening... can we have some screen shots.

That expression definitely works... I've just built a flow using it.

HTH

Jay

[ahmadbutt]

@Jay-Encodian creating a item works. But updating a item doesn't work. 

- when a Form is created with a new ID than it created a new item.

- when a Form is modified with the same ID than it isn't updating the item.

[Jay-Encodian]

@ahmadbutt 

OK, but is the expression now working which was the previous issue?

[ahmadbutt]

@Jay-Encodian The condition with True and False was not working. Now it works with False but not with True..

[Jay-Encodian]

@ahmadbutt 

The expresion is working... but the first action inside the 'False' branch is not working? Which means the expression is working but you have an issue with the 'Update Item' action.

Sorry, I'm not trying to be pedantic... but we need to understand where the issue lies.

Thanks J

[ahmadbutt]

@Jay-Encodian There is something wrong with the Update item.. I think It is the 'Id'. I don't know what to fill in there. I tried the 2 things shown in the picture (Id and list of ..... Id). If I do list of ..... Id than it created a new row instead of updating the row.

[Jay-Encodian]

@ahmadbutt 

That should be the 'Id' column from the 'Get Items' action... note Flow will automatically add an 'Apply to Each' loop as the 'Get Items' action returns and array...

HTH

Jay

[ahmadbutt]

Now the update item works but it adds a row extra with it.. It should only update the row.

--

[Jay-Encodian]

@ahmadbutt 

Is there more than one item returned in your Get Items action?

[ahmadbutt]

@Jay-Encodian This I got in get items: (Id-test is from the Form I fill in, so it is just one id)

[Jay-Encodian]

@ahmadbutt 

Can you please check the run history to verify what is returned? Showing the query doesn't check what data was actually sent back 😉

[ahmadbutt]

Do you mean this?

[Jay-Encodian]

@ahmadbuttyes, check the body data as every item in the array will be processed by your 'Update File' action

[ahmadbutt]

@Jay-Encodian Uhm I don't know what u mean. It is updating the item but it adds the same item again in SharePoint. From the body I can see that it works?

[Jay-Encodian · Accepted solution]

@ahmadbutt 

The 'Get Items' action could return multiple items... if it did your 'Update Item' would run multiple times.

I was asking you to check the 'Body' value of the 'Get Items' action to verify the number of items returned... you could also page through the... but to do is the simple way just check how many times the 'Apply to each' loop has run.

[ahmadbutt · Accepted solution]

@Jay-Encodian @v-litu-msft @manuelstgomes The problem was that I had 2 flows open with the same Flow. I had copied it.. So the flows ran 2 times. I turned 1 Flow off and that was the problem. Sorry for this.... and thanks for the help again.