Unanswered

Remove a row in Excel if a User Doesn't exist

(0) Share

Report

Posted on by Community Power Pla...

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!

All responses (2)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Remove a row in Excel if a User Doesn't exist

Thanks for the suggestion! I tried that and it ended up removing all the rows in Excel. I tweaked it to say Excel Unique ID Doesn't contain O365 Unique ID and still nothing. Not sure why I'm struggling with this so bad.. Thanks for the help though!
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: Remove a row in Excel if a User Doesn't exist

Hey @Anonymous

You can probably add a parallel branch to check for items that exist in the array of excel output but not in the users output and delete it :

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!