Unanswered

Problems with rows updating

(0) Share

Report

Posted on by George1234a

Good afternoon!

I have an excel file with daily support incidents, which I receive everyday by my colleague in Outlook, after that I save it in SharePoint and update main excel file with support incidents registry. I want to automate these processes:

1. Saving excel file from Outlook to SharePoint - Done it already;

2. Creating a table in saved file - Done it already;

3. Updating rows in main excel file - Can't do it!

When I try to add this flow, it doesn't show me "future" columns, because file isn't created yet. Tell me, anyone, please, how to that flow? Or maybe you have another way to do it?

Thank you!

Categories:

General topics

I have the same question (0)

All responses (18)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@George1234a

While I don't totally understand the workflow you have described, it appears as though you can simply save what doesn't yet exist and retrieve the rows again that you want to use.

Was this reply helpful? Yes No
George1234a 10 on at

Like (0)

Report

Yes, but I want to automate these processes, my colleague send me an excel file, it saves automatically on SharePoint folder, after that it creates a table into that saved excel file (because into that file are only columns, but they aren't as a table column), finally that file needs to add new rows in my incidents registery. Is there any other way to automate these processes behind I wrote above?

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@George1234a

Data in Excel must be in a table for Power Automate to retrieve the data - no work arounds. If I understand you correctly, the issue is that the data is in the Excel file is not in a table. There is an Excel for Business Create Table action.

The issue with the action is that you must know the cell range in order to create the table. Do you know the cell range?

Was this reply helpful? Yes No
George1234a 10 on at

Like (0)

Report

No, there is a data in the table, I know cell range in the file, but in the action "Update a row" it doesn't show me columns name, because the file isn't created in the SharePoint yet (because I don't receive it yet), after I receive it saves in SharePoint->Creating a table in saved file->Updating rows in main excel file (registery)

Was this reply helpful? Yes No
George1234a 10 on at

Like (0)

Report

Was this reply helpful? Yes No
George1234a 10 on at

Like (0)

Report

My flow looks like this:
2. Action "Update a Row" looks like this, but there is no column in the left, because file doesn't exist now (not created in SharePoint):
3. But If I write not a dynamic file (I created for example), it shows me columns in the left:
So where can I take column names if the file isn't created but I know what name they will have?

Was this reply helpful? Yes No
majorfriend 170 on at

Like (0)

Report

Hmm, not sure I am understanding correctly.
Wouldn't the rows you want to update be in the main excel file (and wouldn't this file already exist and is not created by your flow)?
Or is your flow creating the main excel file?

Was this reply helpful? Yes No
George1234a 10 on at

Like (0)

Report

Main file is already exists and placed in common folder with the file I receive everyday, everything I want - rows in the main file must be updated by received (everyday) file, they have same columns

Was this reply helpful? Yes No
neerajsu 68 on at

Like (1)

Report
@George1234a : The problem is not because your file isn't created. Its because, you are giving id of the file created in previous steps. This is a generated value, not a static value. Flow has no clue what the File id value can be, because it can be anything and it will only know when the flow runs. So it cannot retrieve the Table headers from the excel sheet.

Now this does not mean you cannot update the row. You still can.

Click "Show advanced options"
Notice the field "Provide the item properties"
Add the following values in there {"ColumnHeader1" : "Value1", "ColumnHeader2" : "Value2", "ColumnHeader3", "Value3".......}
Since I don't know Cyrillic I just used ColumnHeader1 2 3 etc, but I hope you get the idea.

Hope that helped.

Was this reply helpful? Yes No
majorfriend 170 on at

Like (0)

Report

So for your update a row step you should select the file in the common folder, instead of using the Id from the create file step (this would update rows on the new file, not the main file). However, if I'm misunderstanding and you need to update rows on the created file then @neerajsu's solution should do the trick.

Was this reply helpful? Yes No