I have a problem in PowerAutomate. I created a flow that updates an “output” excel file based on changes I make in the “input” file. Both files contain the exact same columns and lines. The flow looks like the picture 1 (English translation of the elements on the left side).
In the last step “update a row” I listed all lines from the “output” table and individually selected all lines from the “input” table to align the columns in each table (since it’s like 300 columns that was a pain, I also appreciate any help on how to do this faster/for multiple lines at a time). I used the lightning symbol each time to list the present columns. Please see picture 3 (couldn't upload picture 2 because of restrictions only uploading 3 pictures).
Here comes my problem: I can’t save my flow after al this manual work. The problem seems to be the “/” signs in the column titles. When I remove this column, the next column with a “/” in the title causes this problem. I have like 300 columns out of which the most contain a “/”, so it is not really an option to remove it from the titles.
The error note:
Fehler beim Speichern des Flows. Code: WorkflowOperationParametersExtraParameter, Meldung: "The API operation does not contain a definition for parameter 'item/ Pieces MPL 25.26'.".
In the error note, the “/” has been replaced with a “.”. When I hover the mouse over the added column (picture 3) the “/” has been replaced with “~1”. See picture 4.
Does anybody know how to solve/workaround this problem, without renaming the columns ? I have PowerQuery connected to the output file and the input file is a standard template, thus would like to avoid changing the column names.
2
Share
Report
All responses (
Answers (
