Unanswered

Check the roster, delete the person from training list if not part of the roster

(0) Share

Report

Posted on by 3cdoug

153

So in my company we have mandatory trainings and I developed an app to upload the training and store the information into a sharepoint list

I am now trying to create a flow that cycles through the trainings sharepoint list checking employee id

If that employee id is no longer in the company roster those trainings are deleted from the training sharepoint

With the screenshots I provided when I run that flow it deletes all the items from my sharepoint list

Any help/ideas would be greatly appreciated

Categories:

Building flows

All responses (6)

Answers (0)

Sort by

creativeopinion 10,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Your Filter Array action should be happening outside of the Apply to Each loop.

Please refer to this post for instructions on how to use the Filter Array action properly. This post covers how to cross-reference items to a SP list.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok
3cdoug 153 on at

Like
a
(0)

Report
Copy link

Link copied!

Alot of good information, Im just a bit lost in all the flow but I will give it a go. Thank you
creativeopinion 10,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Take it step by step and run a test where I indicate to run a test. It will be easier to troubleshoot your flow this way rather than trying to build it from start to finish especially if you are new to PA.

I personally find it more efficient to build a flow by testing at each section to ensure I'm returning the correct values. If you aren't returning the correct values, the next actions won't run anyway.

Good luck!
3cdoug 153 on at

Like
a
(0)

Report
Copy link

Link copied!

so to know make sure I am checking my sharepoint list for employee ID and cross checking that with the employee roster. Am I on the right track?
creativeopinion 10,508 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

As long as the Employee ID Excel corresponds to the Title Value in SharePoint.

If you run a test (without the apply to each action). The values returned in the Select on both branches of your flow should return values that you can cross-reference. Otherwise you aren't going to be able to filter any items out with the Filter Array action.

Hope that makes sense.

Is the Filter Array action returning anything?
3cdoug 153 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, they both returned the id from each table. I just didnt know what to do after that to actually make the correct deletions happen