Run a Power automate flow without a button

Hi KevinGui14 ,

Sign in to your Power Automate account.

Select Create > Scheduled flow.

Specify the start date and time for your flow, and how often you want it to repeat.

For your requirement, you can set it to repeat every day in the morning at your desired time.

Since you mentioned using a switch to send an email and then saving values into a table, you will need to replicate this logic in your new scheduled flow.

Use the New step button to add actions for sending an email and for saving data to your table.

After configuring the actions, save your flow and test it.

For more detailed guidance on creating and managing scheduled flows, you might find the following documentation helpful:

Run flows on a schedule in Power Automate - Power Automate | Microsoft Learn

Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!