cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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
Highlighted
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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,931)