Skip to main content

Notifications

Power Automate - General Discussion
Answered

Read in a text in flow

(0) ShareShare
ReportReport
Posted on by 11

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.

 

Categories:
  • Adalsteinn Profile Picture
    Adalsteinn 11 on at
    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.

  • Verified answer
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard