Flow fail to update rows

[Anonymous]

Hey guys,

[Anonymous]

So, I have many flows that collects response details from forms and updates rows on an excel worksheet with submission time, everything have worked fine, but last week I added 20 more people from the same organization (total of 100 people in the worksheet now) and for some reason only like 10% of these names work in the sheet (old names still work)

So, when a person submits a form, response details are collected, user profile is collected and a row is updated. I have double checked the names in the domain and it is always like Lastname, First name @ CompanyName. I have checked the forms and the people have submitted the form and I'll get an error on flow that says:

"status": 404,

"message": "No row was found with Id 'Name, Name @ Company'.\r\nclientRequestId: beac05f8-3265-419a-ad21-86eef93a6769\r\nserviceRequestId: b67ca0e3-44c1-48c2-9b07-f381c236074f",

"error": {

"message": "No row was found with Id 'Name, Name @ Company'."

},

"source": "excelonline-wus.azconn-wus.p.azurewebsites.net"

}

These names are clearly in the table, but only a handful of these new names work? So to be clear, let say that we

have four people:

Ericsson, John @ Testcompany

Stevenson, Fredric @ Testcompany

Quin, Eric @ Testcompany

Jonson, Andreas @ Testcompany

Only John and Andreas work even though all four have submitted the form.

Please help, thanks!

Andreas

[efialttes]

Hi

You are getting rows with 'List rows present in a table' action block, right?

If so, Are you applying any ODATA expression in Filter  Query input?

Hope this helps

[Anonymous]

Yea,

Get response details - Response ID = triggerbody() = triggerBody()?['value'][0]?['resourceData']?['responseID']

Br

Andreas

[efialttes]

Hi again

Can you share a screenshot of your PA Flow in edit mode, expanding all the cards and giving details of each expression you currently use, so we can understand better the challenge?

BR

[Anonymous]

This morning when I sent out the link to this week form (Week 7 form) it worked for the first 3-4 people who submitted, not it doesnt work anymore. When I check the flow history it says "No row was found with Id 'Hey, Man @ Company'. even though there is a cell with that exact name. I have added my own name within the list and try and it works fine. Its like it only works occasionally

[Anonymous]

Ill give you an example, on the pics below you can see the name of the person in the Excel table, and the name of the same person in the "failed flow history"

[efialttes · Accepted solution]

Hi again

It sounds realliy weird 😞

Do keys for all failing rows have anything in common? Every single failing row has @ but the successful ones not, or they have leading or ending spaces and the others not...

Hope this helps

[Anonymous]

That is the weird part, there really is nothing that differs between those who succeed and those who fail, there is a couple of people with @ that work, and a couple of ppl without @ that work/does not work

[Anonymous]

WTF.. seems to be a space between those that doesnt work

[Anonymous]

That might have been the problem, haha. There was a space in the end of the names on the new ones I have added, that might explain it. Ill have to wait for some more ppl to submit but hopefully that was the issue

[Anonymous]

Yup. The problem was the spaces within the Excel table. Lol. Now I works, thank you so much dude 🙂

[efialttes]

OMG... One possible approach to avoid this problem in the feature is to either use trim() for comparations purposes or use contains() instead of equals().

Glad to hear the nightmare turned into a happy ending!