Dear all,
Please could someone assist in building a flow for the below requirement,
We have two tabs in a excel, one consolidates a response from the team and another a roaster in which actual employee working status has to be updated daily against the planned.
Details on Tab1:
Literally, the data will be appended in the below table for all employees (with their work status) on daily basis,
| Emp ID | Name | Email | Date | Status |
| 909890 | John David | xxxxxxx | 16/08/2022 | WFH |
| 909890 | John David | xxxxxxx | 17/08/2022 | WFO |
Details on Tab2:
Working status (planned) will be available for the entire month before a particular month begins, and actual working status has to be updated on the respective column on a daily basis based on the details from the above table in a different tab.
| Emp ID | Name | 16/08/2022 Planned | 16/08/2022 Actual | 17/08/2022 Planned | 17/08/2022 Actual | 18/08/2022 Planned | 18/08/2022 Actual |
| 909890 | John David | WFH | WFH | WFH | WFO | WFO | |
Can someone help in creating a flow to dynamically identify the correct column for each day and update the working status of the employees in the respective row (all the rows on a particular column needs updating) and the next day the flow should identify and update the column associated with the respective date and so on.
