Power Platform Community Forum Thread Details

Group,

Tried looking through past articles, but can't find where my flow is failing. I'm pretty new to flow, FYI.

I'm trying to update a sharepoint list with values from a SQL query. The SQL is in line, and it seems to match the sharepoint list, but I keep getting the following error on the condition step:

"status": 400,

"message": "Route did not match\r\nclientRequestId: 17539288-b96f-47f6-84b0-7d2d0775e485\r\nserviceRequestId: 17539288-b96f-47f6-84b0-7d2d0775e485"

I'm obviously doing something Flow doesn't like, but I really can't tell what that is with the provided information. I've rebuilt this flow as well ( a few times).

Thanks,

Flow after running:

Showing that I am grabbing the correct item and applying it to the right item (I think!)

Page one of my flow in edit mode:

Page 2 of my flow in edit mode:

Categories:

Using flows

Hello @mathewschultz

Did you find a solution to your need or is the need still relevant?

Looking at your flow, I would say that you have too many steps.

The Filter array step is unused (not referenced) and seems not to be necessary as the Get rows step already filters on the invoicenumber.

The condition step in the inner loop (Apply to each 2) is not necessary, as the row(s) only are those (the one) with the invoicenumber that you are looking for.

The Update item step references Current item in the Id column. That is incorrect, it should be the Id of the list item (Get items), so either locate the list item Id or use the expression "items('Apply_to_each')?['Id']".

Anyway, let us know how it went for you. Kind regards, John