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 / Recurring Flow and Exc...
Power Automate
Answered

Recurring Flow and Excel Updates

(0) ShareShare
ReportReport
Posted on by 4
Good morning.
 
I am trying to create a recurring flow that will update a particular cell in an excel sheet from a Teams site.
 
Now, that part is easy enough, however, what I am wondering is, how could I make the "Table" value change each day in the same recurring flow.
 
For some background, the excel sheet is created and monitored by someone else, and each morning, they add a new table with the current date in the format "APR 22, 2025", then "APR 23, 2025", and so on.
Each day, I am wanting to automatically update the new table. It will be the same cell needing updated each day.
 
Is this something that is possible? Any ideas or help would be greatly appreciated!
 
 
Categories:
I have the same question (0)
  • Verified answer
    rzaneti Profile Picture
    4,262 Super User 2025 Season 2 on at
     
    Yes, you can achieve it :)
     
    Here is a quick example. We have a table named with today's date, and let's say that we want to set the "done" column from record with id 3 equals to Yes:
     
    One important flag here: your Excel tables cannot have blanks in the name, so "APR 23, 2025" would not be valid, for example. 
     
    The flow will have simply 3 steps, but for your case you must go with a Schedule trigger instead of a manual one: 
     
     
    In the Compose, we're using an expression the current date/time (utcNow) and format it as monthday_year (in red). The format will depend on the specific naming convention used by your organization and you can find more details on how to format dates and time in Power Automate in this blog: https://digitalmill.net/2024/04/26/date-and-time-format-strings-in-power-automate/
     
    If I run the expression today, this will be the value:
     
    Finally, you will populate the Update a row action like below. For Table, you must use the dynamic content from your Compose (in red). For Key Column, you can manually type the name of the column to be used as reference to identify the cell to be updated, which in my case is id (in blue). For Key Value, the respective identifier for the row to be updated (in green). Finally, you can provide the values to be updated in an object format (in yellow), where the key corresponds to the column's name ("done") and the value to the value that you want to insert into the table ("Yes"):
     
    After running the flow, this is the output:
     
     
    For further reference, I'm sharing a few content that I created that are related to the topics discussed in this response. 
    - Video: Using dynamic content in Power Automate - https://youtu.be/jpledJfaEPQ
    - Blog: Handling date and time in Power Automate - https://digitalmill.net/2024/04/12/handling-date-and-time-in-power-automate/
    - Blog: Date and time format strings in Power Automate - https://digitalmill.net/2024/04/26/date-and-time-format-strings-in-power-automate/
    - Blog: Inserting and updating data into Excel Tables with Power Automate - https://digitalmill.net/2023/07/24/inserting-and-updating-data-into-excel-tables-with-power-automate/
    - Blog: Writing expressions in Power Automate - https://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/
     
    Let me know if it works for you or if you need any additional help!
     
    If this solved your issue, please mark it as Accepted Answer.
    👍 If it helped, feel free to give it a like!

    🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
    💼 Find me on LinkedIn
     
  • RF-22041420-0 Profile Picture
    4 on at
    Incredibly detailed info @rzaneti, thank you so much!
     
    That is exactly what I needed!

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 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard