Power Platform Community Forum Thread Details

This is the first time I post in this community. I'm basic learner in Power Platform that have some problems to ask for help.

I created an Excel file named 'Test001' to demonstrate how to use Power Automate Cloud to generate running numbers. However, I encountered an error with the running number functionality when manually running the flow every 1-2 minutes. I will provide a detailed explanation below. To begin, I created a table named 'Table1' (shown in the picture below) and inputted the initial data in the first row (ID 1).

Next, I created a flow in Power Automate Cloud (shown in the picture below) using two main actions: "List rows present in a table" and "Add a row into a table." This flow aims to generate a running number ID (1, 2, 3, 4, etc.) and a timestamp for each new row added to the table.

I tested the flow in Power Automate Cloud and checked the results in the Excel file (shown below). Rows 3-6 were generated successfully by manually running the flow every 4-5 minutes. However, when I generated row 7 around 1-2 minutes after row 6, the running number was incorrect. The ID should have been 6, but a different value was generated instead. Upon inspecting the "List rows present in a table" action in Power Automate Cloud, I noticed some errors (shown in the picture below). It seems that Power Automate Cloud might require a waiting period before generating the next running number. Is it usual for Power Automate Cloud or Excel? if I adjust this flow for continuous flow, I should add action "Delay" in this flow in each loop? I would greatly appreciate any insights or suggestions from the community to help me. Thank you in advance for your time and assistance.