Please help me, because i'm so dumb and spend so much time on this.
I have created form in Plumsail with name, phone, table with a couple of fields and amounts.
So, in flow, i parse it and stuck.
I need to separate an array into two array by category of the product in my table, create 2 docx files out of them and send them to two different e-mails.
I just dont what instrument to use. Condition not working, filter not good for my case.
If you want to create 2 docx files out of the separated arrays, I afraid that there is no any way to acheive your needs.
You could take a try to create 2 excel files out of the separated arrays, and the screenshot of the flow should as below:
You could use two Filter Array actions to get the two separate arrays.
I don't understand the structure of your data, and why a condition nor a filter won't work.
I would suggest an iterative approach so that you can split out your data and emails by any number of product categories and not just two. If it is always true that the data is one or the other, I would suggest solving the binary condition of the form side and not in Flow. Build two separate forms or have a distinguishing question to trigger off of.
To solve for any number of product category conditions, say your data ultimately looks something like this:
Name | Email | Product | Product Category | Attribute 1 | Attribute 2 | ... etc
1. Add an Action to get all rows of your data
2. Add an Action to get distinct rows of your data
3. Add an Apply to Each loop
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!