If the goal is to consolidate, you'll need to move the actions from your first flow into the daily occurrence of the second flow. Instead of triggering on the file creation in your first flow, incorporate the logic of receipt extraction into your second flow. To achieve this, list all the files in the receipts folder using the "List all files in a folder" action. If there are files (use a condition statement to check the length of the response), create the excel file.
Next, use an "Apply to Each" loop to iterate through each file, extract the content of each file, and add the rows to the Excel file. Additionally, add a delete file (or move) action to remove the original receipt file so it doesn't get re-processed in the next flow run.
Outside the "Apply to Each" loop, create a shareable link to the Excel file. Ensure you place the rest of your Flow 2 actions outside of the "Apply to Each" loop so that only one email gets sent with the attachment.
Consider using SharePoint as your main repository for this process. You should be able to perform all these actions without tying them to a user's personal OneDrive workspace. This is beneficial as a SharePoint folder is already in a shared space and provides more permanence, as it's not linked to a user's account.
Hope this helps!
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt
