Forum Discussion

MIA-27's avatar
MIA-27
Regular Visitor
2 years ago

Update master excel file connected to PowerApp Teams table

I am working on a project of data of monitoring system of machines.   I have a excel file called MasterDataFile having table - its data of all the machine info with some column name like Model, Ser...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MIA-27 ,

Please follow this steps:
1.Import CSV File into Excel.
2.Once in the PowerQuery Editor, you can perform any data cleaning or transformation that your CSV data might require to make sure your CSV file has columns for Model, SerialNumber, HourMeter, and Location that can be matched with your MasterDataFile.
3.Click on Home > Merge Queries. Choose the table from your MasterDataFile and the table from the CSV file. Use the Model and SerialNumber columns (or other columns) as the keys for the merge. Select the type of join that suits your needs (likely an Inner join in this case).
After merging, you'll see the columns from your CSV file alongside the existing columns in the MasterDataFile. You can now create new columns or replace the existing HourMeter and Location columns with the corresponding columns from the CSV file. For example, you can use 

if ...... then ...... else ......

to create a new column.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MIA-27's avatar
    MIA-27
    Regular Visitor
    2 years ago

    Thank you so much for your reply.

    Tried to read your advise several times, but not able to complete the requirement,

    I was able to bring side by side of the column  "service meter" of the master file and test file.

    But how to automatically replace the latest data of testfile  to the master file data.

    below is the screen where I am stuck: