Unanswered

Update item skipped

(0) Share

Report

Posted on by joel914823

557

I have a flow - where item is created, then looking up to two different places 1. Employee table to get the employees EID and an Excel file to look up the state of the store number - then updates the record with the information. When the store number is found - the update item works fine, but if the store number entered is not in the excel sheet, the entire update item step is omitted - so it doesn't give the EID nor the state. Screenshot 2024-03-27 112306.png

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @joel914823

Few doubts

1. Why 2 for each is used here ?

2. Also is update item is updating any other list apart from Employee List ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report
Copy link

Link copied!

the Update item, is updating from two outputs (from the employee list in Sharepoint and from the LDB Export from Excel) I was wondering why the two apply to each, I tried to separate them, get items from sp list, update item, then list rows present , then update, but Power Automate on its own thru it into a double apply to each. @Nived_Nambiar

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report
Copy link

Link copied!

The odd thing is when the value is found in the 'list rows present in a table' step, then it works but if that value is not found (essentially the output of the 'list rows present in the table' is blank - then the entire Update item step is skipped

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @joel914823

I got the reason now

Since both actions - Get items and List rows return as array of values > so whenever using its dynamic content > it will create a loop around. To avoid creating a loop use first() function around value output of get items and list rows. That will prevent creating a loop.

For more idea > refer the article - https://www.shahryarsultan.com/2022/05/power-automate-functions-first-last.html

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No