However , the new responses the are not synced if the Excel file is open on the web. This doesnt work for Power Automate as someone has to open the Excel every time to sync the latest responses.
Is there a way to solve this issue, like using Office script etc?
The "htttp call action to sharepoint" in power automate doesnt work in every organization