0

I have to somehow synchronize several lists. I started off with my previous question here:

generate lists from another

To wrap it up, my current problem is, to find out, if the title from my master list is already present in one of my autogenerated lists, or not. Everything else (adding elements to my lists depending on column contents, etc.) works.

I tried to follow the instructions as well as possible. But I'm stuck when I should enter the infamous @equals(length(body('Get_items')?['value']), 0) as a condition for branching. I never get to the "complex mode" which is referred to everywhere. Step 1

Step 2

Step 3

Here is where I'm stuck. Where can I continue? Where is the window or field to put the formula? Or to put it the other way: How can I construct the formula by mouse clicks?

Update

I think I got a little bit further, but stuck again. I was able to add the filtering. Here's the next hindrace:

condition entered but fails That's my error message: Error message

It loosely translates: "Error while checking the template: 'Get_Items' referenced in 'input' in action 'Bedingung_3' is not defined in template"

Where do I have to look next?

1

In your Get Items action (which I believe is your elemente abrufen action), you need to specify an ODATA filter query (I believe the German equivalent is abfrage filtern). Set that value to Title eq <<insert Flow reference to original item's Title>>.

Then in your first Condition after the Get Items, you should use dynamic "Expression" (sorry, I don't know what the German equivalent for "Expression" is, but it is the second tab in the "Dynamic Content" box that pops up when you edit a value) to specify equals(length(body('Get_items')?['value']), 0). Although this formula is checking that there are zero items, you actually probably want to validate that your query returned exactly one item equals(length(body('Get_items')?['value']), 1), then, rather than looping through them all (Auf allen anwenden), you just want to look at that first item body('Get_items')?['value'][0]. Maybe initialize a Object type variable earlier, so that in the condition block you can Set Variable to body('Get_items')?['value'][0].

  • I updated my question concerning my next problem. I'd be glad if you had a look upon it. – Ariser yesterday
  • It's difficult to tell just by screenshots, but my guess is that you need to replace any reference to Get_Items with Elemente_abrufen – willman yesterday
  • Any expression that uses body('something_here') is getting a reference to the body output from one of your previous actions, so you need to know the internal name of the action you want to get data from. If you use the "Peek Code" option on any step, it will show you what that action's name is. In most cases, it will be the name you gave it in the UI, but with spaces replaced with underscores. – willman yesterday

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.