I have two lists in separate site collections that have identical structure. When the master list is updated, I want it to update the child list, and when a new item is created in the master list, I want it to create the same item in the child list. So far, I've gotten a flow working and claiming that it's succeeding, but it's actually not. When I look at the run history, it shows that the condition was correctly met, and triggered the correct path, but the action it was supposed to take never happened.
Here's the screenshots:
First part of Flow is looking at a list in the site collection "contenttypehub". I created a new item with the Customer name of AAAAAA.
Next it looks in a list with the same structure and name in the site collection CustomerManagement, to see if the item with Title (renamed Customer as a display name) = AAAAAA
There isn't, because it's new, so it correctly follows the No path... but the Create Item process is grayed outI've seen that other people have had similar problems, but it turned out that their condition was failing. Mine seems to be meeting its condition, but just refusing to do what it's told.
Here's the view of the flow from the edit page:
When an item is created in the first list, get items from the second list where the title = "Customer" field from the first list
The condition's looking for whether there's anything in the output of the Get Items. If there isn't, because it's a new item, then we apply to each.
The condition is:
equals(length(body('Get_items')?['value']), 1) equals true, and that part seems to be working correctly.
When I get down to the apply to each, the only available dynamic content is "value", and then I'm pulling Customer, etc from that.
The only dynamic content here is "value" from Get ItemsI'm... guessing that the failure here is that "value" is actually the output of the last step, the Get Items, which found nothing so of course it doesn't work, and it's confusing because the lists have identical structure and identical fields. But the thing is, the only option I'm offered is the "value" that represents the list of items from Get Items. I'm not given an option to use the values from the item I created in the beginning, even though the flow obviously knew what those values were because it correctly converted the variable for Customer to "AAAAAA". How do I get the item that was created originally to be a stored entity that I can draw from? I've tried running a "Get Item" right after the initial creation to pull back the item I just made or modified, but it doesn't then show up as an option to draw values from.
