web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Storing Persistent Data?
Power Automate
Answered

Storing Persistent Data?

(0) ShareShare
ReportReport
Posted on by 7

Hello. I'm new to Power Automate and I have been tasked with making a recurring "Out of office" flow. I successfully made a system that replies to message on indicated days. Unfortunately, donotreply addresses and the like cause infinite loops when they also respond with an automated message. Is there any way to keep an array of the addresses I have replied to that persists between times the flow is triggered? Is there a way I could connect to an Excel workbook and store the data there?

 

TLDR; Need to store an array between flow instances.

Categories:
I have the same question (0)
  • Verified answer
    Caspar_Rubin Profile Picture
    831 on at

    Hey,

     

    that's possible, I hope I understood correctly. This is how I would do it:

    In your Excel file, make sure you have a "real" table. (Insert -> Table). In my example, it's called Table1 and it has a row called E-Mail and one called RespondedAt. The Excel is saved in my OneDrive and I saved it as Flow_EmailResponses.xlsx.

     

    Caspar_Rubin_0-1663860910269.png

     

    In my flow, I then use the action List rows present in a table at the top to get all rows. 

    Add an Apply to each action to loop the rows. In the Select an output from previous steps field enter the Dynamic content value from the Excel action.

    Inside the Apply to each, add a Condition action to check the E-Mail Address from the trigger (From) with the E-Mail row value in the Excel table.

    In the If yes section, you don't do anything because in that case, it found the E-Mail address in the file. 

    In the If no section you can add your logic / reply. 

    At the end of the If no section, use the Add a row into a table action to add the E-Mail address and maybe a timestamp to the Excel file. 

     

    Next time this person sends you an E-Mail,  the flow will go to the If yes section, because the E-Mail address is in the File.

     

    Caspar_Rubin_1-1663861196084.png

    cheers

     

     

     

     

     

  • NottheITguy Profile Picture
    7 on at

    This is exactly what I was looking for but I couldn't quite work out how to manipulate Excel. Thank you very much.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard