Power Platform Community Forum Thread Details

I'm automatically populating an Excel (for web) sheet with data from Forms. Every form creates a new row in the table, but always puts it at the bottom. I can manually sort by date, but I'd rather it happen automatically.

So I've created a script to sort by the date column, and I've created a Flow to activate this script on receipt of incoming Form data. But it's inconsistent.

Some data is input on a form while the workbook is closed and the data will appear when it's opened, but that doesn't trigger the Flow. With the workbook open, the first data input doesn't trigger the Flow. The *second* data input *does*, but it seems like it triggers it before adding the new data to the table, so the *first* data input is moved to the top, but the *second* is still at the bottom. A *third* form input actually sorts the entire table including the data input in that form.

There doesn't seem to be a way to trigger a script when the workbook is opened. I *can* set it to trigger at given time intervals, but that wouldn't really accomplish what I'm trying to do. I can also create a button to press to trigger the script, but given that this is a web app rather than a desktop app, that actually takes longer than doing it via the table's controls.

There *must* be a way to consistently have new data appear at the top of the table. Just having the Flow trigger when the workbook is opened and consistently sort the entire table *every time* there is incoming data would work.

Any suggestions?

Categories:

Building flows