cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KuhnsKC
Frequent Visitor

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

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!

 

1.png2.png

 

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!

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

Hey @KuhnsKC 

 

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 : 

ff3.PNG

 

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!

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!

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,013)