If item exists already - update multiple items based on the trigger ID

(0) Share

Report

Posted on by Ronja

If item exists already - update multiple items based on the trigger ID

Hi everyone,

I once again have to rely on peer knowledge, because I just can't get it to work.

Scenario:

List 1 = all items in native language

List 2 = all items are translated in every available language

--> Objective: update this item in all languages in list 2

If an item is now created / modified in List 1, my goal is to check whether the items are already existent in List 2 in all languages. So with 10 languages there should be 10 times the initial item from list 1.

However I just cannot get the filter to work to tell me whether these items already exist or not, it's always equal to 0.
The filter functions with a column called "OriginalID" containing the ID of the trigger item.

I'd appreciate your help very much!!

Multiple tests with changing the length output to the get items action / filter array / filtering for different columns have been conducted without any change in outcome.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Ronja The issue is with your condition action in your Filter Array action.
The condition above is asking whether the value of the OriginalID is equal to [variable]. OrignalID in your condition is a string of text. Your Filter Array action will always return 0 items unless your variable is equal to 'OriginalID'.

You need to insert the OriginalID dynamic content into the Filter Array action.

A variable in your case isn't necessary.To learn more about how to use the Filter Array action, please refer to this recent YT Tutorial I uploaded.

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Ronja 24 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion thank you so much for your help!

Unfortunately it doesn't change a thing if I use the variable, the dynamic content of the trigger outputs nor is it working using the length of the value of the get items action.
I really tried everything.
I am suspecting is has to do something with finding more than 1 item. I am just lost why the filtering doesn't work. 😞 Maybe you or someone else has another idea why that is the case. Thank you!!

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,508 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Ronja Apologies I might have miscommunicated. The issue is with your FIRST value field. The first value you've inserted into your Filter Array action is a string of text.

You need to insert dynamic content into the first value field from the Get Items action. I would also recommend you replace your Initialize Variable action with a Compose action instead. This will allow you to view the outputs of the Compose action so you can confirm the value (or string of text).
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Ronja 24 on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion Thanks!! That helped, sometimes simple things can get us stuck 😂

I have one further question-

for the update item action (so for every item in the original list exist 10 items in a seperate list)

How can I make sure that I update all items with the same original ID but in different languages. The different apply to each loops are now really confusing and I don't really know how to proceed nor how to start. Your help would be again very much appreciated 😌

Was this reply helpful? Yes No