
Announcements
Hi Guys,
Trying to create a back order mail merge to inform customer about back order products from their orders.
So I have an excel sheet on one drive which I'm bringing in.
Then finding duplicates and the doing an 'apply to each' to find the list of products to create a html table to insert into a mail.
I for the life of me can't get the filter array to find the order number to pull in the products.
I have managed to create a 'compose' and enter to order ref in which worked, so must be something I'm doing in the process and feel I need to convert the data somehow.
Sorry, a newbie (yes another one) so be gentle.
ps been trying to follow the following post:
http://johnliu.net/blog/2018/6/do-group-by-in-flow-with-two-simple-elegant-loops
But this is starting with a sharepoint list and not excel sheet