Answered

Excel Script says run successful but didn't - reset filter

(0) Share

Report

Posted on by Community Power Pla...

Hi there,

I've been using a flow that parse emails then insert a new row into an online Excel table. And l learnt recently that if the user left filters applied on the table the insert action will fail.

Therefore I came up an idea that to build another flow that runs on every Sunday to reset the filter, to prepare for the Monday's inserting flow runs. I've used the excel script feature to archive this. However even the run history says run successfully but the table is left untouched. I can manually trigger that script and it works just as expected.

Don't know which step is wrong here as it is definitely not a hard one to build.

Is this a good workaround anyway? I'm open for any ideas here.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

v-siky-msft on at

Like (0)

Report

Hi @Anonymous ,

Could you please share the action steps and code for ClearFilter script?

I just made a test on my side to clear filter by office script, but it works well. Here is my script for your reference:

If your script is great, the issue could be due to the Excel connection, please try to re-create a new script in new worksheet and re-create the Excel Business connection to try again.

Hope this helps.

Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Sik,

thanks for replying on this post.

I used the recorder in Excel to make this script. The script details are the following:
function main(workbook: ExcelScript.Workbook) {
  let tbrecords = workbook.getTable("tbrecords");
  // Clear auto filter on table: 'tbrecords'
  tbrecords.getAutoFilter()
    .clearCriteria();
}

It's no exactly the same as yours as I can see.

Lia

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report

Hi @Anonymous ,

Your script is great and works properly on my side.

All I can suggest is that you need to turn off Excel, and when running Flow, and notice the limits for Office script.

Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi Sik,

I did try to close the excel then run the flow again it still didn't work. Any further ideas?

Regards,
Lia

Regards,
Lia

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

For other ppl's reference:

1) delete and recreate the flow.
2) left excel unopened and the flow ran properly.

Was this reply helpful? Yes No
ClintRB 91 on at

Like (0)

Report

Hi All,

I to had this issue and when I set up a separate test file it work normally and as I expected. Different type of function but same non operation.
What I ended up discovering what the I had two separate table with a table on each. The script running on the second tab and table 2 was affecting the the first tab and table 1.
So I just moved table 2 onto the first tab and then it worked.

Cheers

Clint

Was this reply helpful? Yes No