Hello. Starting from two tables I want to join them using an unique common field and create an array to filter later. I followed steps from similar posts. Everything seem working except final step and general performance.
About final step "Componi2" (a Compose action): I expect to see in the list of dynamic data also the output of "Componi", which is Compose action applied to each item of Filter arrary "Filtra matrice Tab1-sx-Tab2", but no output from "Componi" is available as input for "Componi2".
In details:
"Applica ad ogni" is a "Apply to each" action. As output from previous steps I got "value" of Tabella1
"Filtra matrice Tab1-sx-Tab2" is a "Filter array" action. "Da" ("From") is "value" of Tabella2. Fields on left is "ID" field from "Applica ad ogni", is equal to field "ID" coming from Tabella2.
"Componi" action ("Compose") inside "Applica ad ogni" group have "ID", "field1" and "field2" from "Applica ad ogni", while "field3" and "field4" are from "Filtra matrice Tab1-sx-Tab2" output.
Without last step "Componi2" (out of "Applica ad ogni") the flow runs and checked that output of "Componi" is correct.
When I try to compose "Componi2" I see that I can get as dynamic contents only those coming from Tabella1, Tabella2, "Applica ad ogni", nothing else.
Why there is not dynamic data available from "Componi"?
About performance: I have chosen this way to combine Tabella1 and Tabella2 because I read that's the right way to speed up operation. But with these basic tables (only few records used, just to test the model) takes about 10 seconds to complete output. I checked and output is ok (what expected). What's wrong?
Thanks 🙂
