Problems with rows updating

Like (0) Share

Report

Posted on 8 Jun 2021 19:03:18 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!

All responses (18)

Answers (0)

akshaymane_71 6 on 30 Oct 2023 at 13:08:44

Like (0)

Report

Re: Problems with rows updating

Hi @SILVIA-T ,
I followed your tread & just want to ask how do you get table name ? is it custom value or automatically read from excel/ file
please reply it would be helpful.
akshaymane_71 6 on 30 Oct 2023 at 12:58:42

Like (0)

Report

Re: Problems with rows updating

Hello @Neerajuris

I am also facing the same issue & stumbled upon your post. I tried to query the table by dynamically but failed to load the column names. As you suggested do it by defining using Json in item properties. but it still not loading.

Please help if anyone known this issue
SILVIA-T 38 on 06 Aug 2021 at 14:25:16

Like (0)

Report

Re: Problems with rows updating

Hi @majorfriend

I've found a work around for this. Afer updating the rows I wanted to convert the file to pdf, and I've found that the only way to do that is in onedrive, not sharepoint.
So since I was copying already my file to onedrive, I've tried to update the rows in onedrive, not in sharepoint, and that works!!
This is the flow, in case it helps anyone:

Then I copy the pdf back to sharepoint, because is the final file I really need to send by email.
SILVIA-T 38 on 06 Aug 2021 at 09:00:41

Like (0)

Report

Re: Problems with rows updating

Hi,

Yes, if I change it back It says the table doesn't exists:
"body": {
        "status": 404,
        "message": "No table was found with the name 'Expediente'.\r\nclientRequestId: 5b8d0c04-e0c5-43fb-a320-4746bf6da588\r\nserviceRequestId: a76138db-5125-4cf9-82b4-2ad3d31bf85b",
        "error": {
            "message": "No table was found with the name 'Expediente'."
        },
        "source": "excelonline-we.azconn-we.p.azurewebsites.net"
    }
majorfriend 162 on 05 Aug 2021 at 18:16:16

Like (0)

Report

Re: Problems with rows updating

If you leave the File field with the dynamic content, but erase the GUID found in the Table field and enter your table name as a custom value then test your flow again do you still get an error?
SILVIA-T 38 on 05 Aug 2021 at 15:08:51

Like (0)

Report

Re: Problems with rows updating

Hi @majorfriend

The table I want to update is created within the flow (I have an excel template that I populate with some sharepoint item fields after an approval is done; then I copy this file to a folder also created within the flow and I change it's name. So I know in the flow the name of the new file, the folder, the table name and the key but the file isn't really created yet). I need to update these some rows in the new file created because we have several items and sometimes it mixes values because some approbals are done at the same time (and delays are not solving the issue either).

I've tried your approach, with the existent file and then changing it to the dynamic id, but as soon as I changed it the table value is changed and i get the body field againt (and the same error):

I have another very similar flow and when I use the action get rows with a dynamic ID I have the "provide the item properties" field:

But I don't know why in this flow it shows "body" instead of "provide the item properties":

Thanks!!
majorfriend 162 on 05 Aug 2021 at 14:36:49

Like (0)

Report

Re: Problems with rows updating

Hi Silivia,
It looks like you are using a dynamic file for the file ID.

I would try selecting a file with the table you want to update. This should allow the columns to show and you can enter the update information. After you have done this change the file back to your dynamic ID, enter your custom table value, and test.
SILVIA-T 38 on 05 Aug 2021 at 13:34:05

Like (0)

Report

Re: Problems with rows updating

Hi @neerajsu . I'm trying your solution for a similar issue.

I've got to very similar flows for two sharepoint list. For one flow I can see the "Provide the item properties" field and it works fine, but for the other It shows only "body" ando not "item properties", and I can't set it right

I don't know why in this "update a row" action I get a different option than for the other flow, any ideas?

I've tried the same approach in "Body" but I've got an invalid template error Unable to process template language expressions in action

Thanks!
majorfriend 162 on 09 Jun 2021 at 14:01:27

Like (0)

Report

Re: Problems with rows updating

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.
neerajsu 68 on 09 Jun 2021 at 11:10:19

Like (1)

Report
Re: Problems with rows updating

@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.