Regarding your question about SharePoint and Power Automate, you can consider visiting Microsoft Power Platform Community Forum Thread
This is a specific channel related to Power Automate. You'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction.
You can find answer similar to your question such as: Understanding approvals (timeouts and triggers)
Or you can raise one yourself and the experts there will assist you through this case suitable for your requirements.
Apologies for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited knowledge about Power Automate, so to get a quick and better assistance, let me redirect you in the correct way.
We are willing to help you, but we are afraid of providing any incorrect information that may not benefit you, we sincerely hope you can get a perfect solution with the help of experienced supports and community members. We also welcome any community members to share any idea about your situation if one has related experiences.
As other users will also search information in this community, your valuable vote will definitely also help other users who have similar queries easily to find the correct channel and useful information more quickly.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.