This can also be pretty clearly reproduced manually, when, for example, you have an active Excel spreadsheet, where you've started typing into a cell, and have not closed it, and then try to open a new sheet - Excel will pause that and will not actually open the new document before you close the active cell. This is an Excel thing, and not really a PAD issue.
As @Gidi suggested, the best solution to work around this, is likely to send some keys to the sheet after they press OK. In most cases, sending an Enter or Escape key will do nothing if the cell is not activated, and will close it if it is. But if you send Escape, the changes that the user made will not be saved, so, using Enter is a better idea, if you're collecting inputs this way.
Alternatively, you could simply pop out an input dialog instead, and ask them to populate that, instead of writing into Excel. Then use the Excel actions to write the data into the sheet via PAD, instead of allowing the user to do it. Users and automated Excel files are not really a great idea in general, as the biggest bug in your flow is almost always the part between the keyboard and the chair 🙂
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
