Hello!
First time here but I've found a ton of resources here that have helped me get this far. So I'm trying to have an updated spreadsheet of all users from 365 with various fields so that I can reference them in other Flows (texting with Twilio, emailing, etc.). My current flow takes 365 users, compares them to an Excel sheet using the ID as the unique identifier and if it doesn't exist, it adds a new row and if it does exist, it updates it with most recent information.
The next step I need is if a user exists in the spreadsheet but not in Office 365 (meaning they were deleted) - remove the row from Excel. I'd like to do it within this same Flow if I can. Any help would be awesome!
Hoping I can create a new condition that says if the ID in the spreadsheet doesn't exist in the 365 objects, delete that row.
PS: I used materials online to build this and understand 90% of it but can somebody explain why I need the condition to see if the body is empty in this for it to work? I don't entirely understand what that's doing. I'm assuming I filter the data into the array and then if the array is blank (meaning no matches) then I add a new row, if not then update?
Thanks a bunch!
