Answered

Run Excel script error when passing dynamic file

(0) Share

Report

Posted on by muges01

Hi everyone,

I'm trying run the excel script preview option dynamically on newly created file but i'm getting and error "The parameter 'file' has an invalid value '/Data-03.xlsx'.".

The following is my power automate

Do anyone know how to pass the file dynamically?

The goal of this script is the office script to clean the updated file before the user can utilise them.

Thank you in advanced.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @muges01

Remove everything from the file and search for identifier from dynamic selector and provide that for the file. Can you try this and see if this resolves the issue?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
muges01 65 on at

Like (0)

Report

Hi @yashag2255 are you referring to remove the everything and specify the file name dynamic? If so i have done that and is not working.

Was this reply helpful? Yes No
Verified answer

GeoffRen Microsoft Employee on at

Like (3)

Report

Hi @muges01

Instead of 'File name with extension' use 'Identifier'. That should work. This is documented here https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations

Was this reply helpful? Yes No
muges01 65 on at

Like (0)

Report

Hi @GeoffRen,

That did the trick... Thank very much.

Was this reply helpful? Yes No
muges01 65 on at

Like (0)

Report
Hi @GeoffRen ,

The flow failed for all of them except the first one, wen i drop couple file in the library.
The error message that i'm getting
We were unable to run the script. Please try again. The server experienced an issue and couldn't run the script. Please try again in a few moments.
How can i overcome this issue?

Was this reply helpful? Yes No