i have a file that is created every week on sharepoint with power automate. This file contains a list of employees. when the date is changed it shows who is on vacation that week.
The flow is scheduled to update every wed. It also names the file with the next sundays date. I want cell j1 to either use the file name date or update the date when created.
for example file is created on 11/13/24, the file that is created name is 11/17/24.xlsx. I just need cell j1 to always show the same date as the file name. even if I had to add a table to have the date, I could always use j1= sheet 2g5 to get the date where I need it. any help would be great.
Share
Report
All responses (
Answers (
784
