
Announcements
I have an excel file with key columns and also 365 columns with dates as header in different columns for whole year, My requirement is to read date columns and update in the column with the 'corresponding date' column
For example when Power Automate workflow runs on 10th Jan, it should read the date under the Date Column - Then It should update in the '10th Jan' column only . Not other columns like 9th or 11th Jan.
Is it possible to automate such scenarios in power automate?. How can I build flow to update a specific column as per my requirements?
Please help me out