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
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications