Update and add new record in table using CSV , Excel, and Manually. RRS feed

  • Question

  • Hello,

    I was wondering if it is possible to update an excel table using power query. Any help would be appreciated. Here is my scenario.

    I have a spreadsheet on a SharePoint which I need to keep updated. The Peculiarity with this spreadsheet is that I need to updated using records from 2 or more systems and people from my team can also update it manually. 

    The systems provide the record number, priority, Status, Description, department, etc.. 

    The users update manually the risk fields by giving a risk profile (2 letters), descriptions, Planned resolution date.

    The users may also manually enter a record that does not live in the system.

    The tasks is to be able to update the table without loosing data.
        - If the records exist in the table, updated it without over writing the risks fields
        - if the records do not exists in the table, add the record with blank risk fields
        - if the records exists in the table but not in the import, do nothing leave it as is in the table.

    The imports are in CSV and EXCEL format.


    Wednesday, October 21, 2020 9:54 AM


  • Hi Igambit,

    Power Query cannot do this.

    But it might be doable with Power Automate instead.

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Sunday, November 1, 2020 7:43 AM