Basically, I just need to merge these 2 sheets into a new sheet in a new workbook. After that calculate the overtime pay and sort them by Total OT ($). You do not need to account for repeated names.
hi when i open the flow in the for each file there is only one read range having DT as OTDatatable. for combined data table there is no values. u have to merge two files. then use two read range and based on ur destination give the source file. then from that output use other actions. but sometime i faced error after merging if i use the datatable name directly its showing some error. in that situation u just clone the DT and then use filter, sort and finally write in new excel file
