cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahmadbutt
Helper IV
Helper IV

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

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

forms1.PNGFlow2.PNG

37 REPLIES 37

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?

1.pngHTH

Jay

@Jay-Encodian This also gives the same error.

- false = working = creating a item.

- true = not working...

@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

@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.

1e.PNG

@ahmadbutt 

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

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

@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

@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.1e.PNG

@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

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

--2e.PNG

@ahmadbutt 

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

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

1e.PNG

@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 😉

Do you mean this?

3e.PNG

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

@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?

4e.PNG

@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.

A.png

 

@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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,348)