I have a channel and there are 2 different lists (ms.lists) within the channel, I am creating a workflow in power automate to generate an automatic monthly report based on the lists so within the excel file, it has 2 sheets to represent each list. I have created the workflow like this: create a scheduled flow, add recurrence trigger, get items from lists, create excel file, and add rows to excel sheets. The workflow was successfully tested but the file is empty. can anyone help what this is wrong?
