cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saravana1487
New Member

Excel Column - Dynamic update on daily basis

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 IDNameEmailDateStatus
909890John Davidxxxxxxx16/08/2022WFH
909890John Davidxxxxxxx17/08/2022WFO

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 IDName16/08/2022 Planned

16/08/2022

Actual

17/08/2022

Planned

17/08/2022

Actual

18/08/2022

Planned

18/08/2022

Actual

909890John DavidWFHWFHWFHWFOWFO 

 

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.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,638)