Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
MIA-27
Regular Visitor

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, SerialNumber, HourMeter and Location, Its connected to Dataverse For Teams Table. 

 

Every day  I receive csv file having the update info from another team (which is a system export data), where the HourMeter and Locations gets updated of the same machines .

 

I want to update the Master excel file based on criteria - For example:

If the Model  and Serial is same - Then - Update the HourMeter and Location from the csv file.

 

Unable to understand how to start with powerquery. very much new.

Please guide

 

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

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.

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:

 

MIA27_0-1707239199213.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors