Forum Discussion
leon1davies
Feb 22, 2019Copper Contributor
Bookings data in excel
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?
No RepliesBe the first to reply