cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Adalsteinn
Level: Powered On

Read in a text in flow

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
joseye1
Level: Powered On

Re: Read in a text in flow

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.

View solution in original post

2 REPLIES 2
joseye1
Level: Powered On

Re: Read in a text in flow

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.

View solution in original post

Adalsteinn
Level: Powered On

Re: Read in a text in flow

Hi

 

That sounds like a good solution. Thank you for the reply, I will try it out today.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,118)