Hi all
I have been working on a flow for the past 3 days. The main objective is to send out each week a pricelist to our different customers.
The prices in our market vary from week to week so each week the prices can be different.
I have set it up like this currently:
1. Excel exports 22 Pdfs (1 for each customer) in to a folder called "Pricelist unsorted".
2. Flow Start: The Flow starts when a file is created in the folder "Pricelist unsorted".
3. Sorting: It sorts all the PDFs to different folders based on their name (with a switch case). (The Flow creates a new file with the same contents but a different name and moves it to the sorted folder). The files get renamed to "Pricelist" + current date .pdf
4. Send the mail: The Outlook connector sends a Mail to our customers. It uses the same switch case to send to the right customer as used before. The mail is the same for each customer, we use HTML for that.
The Idea: We have a Text field called "Weather and market report". We need to change that text every week. That textfield is then used in each mail with the HTML, every recipient gets the same report.
The Problem: Thw flow is extremly slow. If I want to edit something it takes way to long to load, save and edit. If we need to go into the flow every week, to change the Textfield we dont want to wait so long.
Need help: Thats why we were wondering if there is a better way to add input to the mail that changes every week. Could we create a normal textfile and then let the flow read what is in that? Or is there a better solution? I am very much a beginner and can't see all the possible actions.
Image: https://imgur.com/kROwNzm
Thanks.
Hi
That sounds like a good solution. Thank you for the reply, I will try it out today.
Hi,
Put the text into a table in excel file. Then, get row in your flow and read cell value. You'll change file and don't change the flow.