Bookings data in excel

Copper Contributor

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