Bookings data in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-355366%22%20slang%3D%22en-US%22%3EBookings%20data%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355366%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I've%20been%20able%20to%20use%20the%20'Get%20Data'%20method%20to%20hook%20into%20my%20bookings%20exchange%20account%20and%20when%20I%20select%20on%20'Meeting%20requests'%20in%20the%20Power%20Query%20editor%26nbsp%3B%20I%20can%20only%20see%20the%20sent%20items%20for%20the%20meeting%20requests.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20gives%20me%20a%20good%20starting%20point%20as%20I%20can%20see%20which%20requests%20have%20been%20cancelled%20but%20the%20problem%20I%20now%20face%20is%20that%20if%20I%20edit%20a%20bookings%20request%2C%20it%20creates%20a%20new%20entry%20and%20doesn't%20remove%20the%20old%20one%20so%20I%20end%20up%20with%20duplicate%20entries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20common%20key%20between%20the%20two%20entries%20so%20I'm%20unable%20to%20find%20a%20way%20of%20removing%20the%20old%20request%20and%20just%20leave%20the%20latest%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense%20but%20does%20anyone%20have%20any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-355366%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi All,

 

So I've been able to use the 'Get Data' method to hook into my bookings exchange account and when I select on 'Meeting requests' in the Power Query editor  I can only see the sent items for the meeting requests.


This gives me a good starting point as I can see which requests have been cancelled but the problem I now face is that if I edit a bookings request, it creates a new entry and doesn't remove the old one so I end up with duplicate entries.

 

There is no common key between the two entries so I'm unable to find a way of removing the old request and just leave the latest one.

 

Hope this makes sense but does anyone have any ideas?

0 Replies