Excel Online (Business) connector "File" setting

(0) Share

Report

Posted on by lk777

124

I have created a flow with Excel Online (Business) /" Add a row into a table".

It uses an Excel file that was created from a template file.

This file rows are populated automatically by the flow.

It works but here is the problem.

If the file was replaced by the file with the same name, absolutely the same structure and the same Table name the flow fails. (Reason for replacing: e.g., a corrupted file needs to be replaced by a new file).

And it fails because a new file has a different ID, I believe. You have to go back to the action and select a file again via a flow browser ("File").

Is there any solution for this problem?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @lk777 ,

You have accurately analyzed the cause of the problem. If a new file is generated, then we need to reconfigure Flow.

Maybe you could consider sharing the details of Flow configuration to us so that we can think about the workarounds available.

Best Regards,

Was this reply helpful? Yes No
lk777 124 on at

Like (0)

Report

Hi @v-bacao-msft ,
This is a flow which populates an Excel table.
A user selects an item from a list and clicks on the button (this list has a column of a button type) which launches this flow.
This is a multi-user/small business (switch-case) with multiple destination files (switch-case).

I wanted users to replace a corrupted destination file on their own (just to overwrite it).

Was this reply helpful? Yes No