You’re offline. This is a read only version of the page.
Announcements
35
I have a sharepoint Table called Coaching and I need to fill it out with team member's hire date. Access Matrix is my employee table with all the info - I am trying to pull data from the access matrix - when the Hire Date is blank & employee EIDs match in both tables. My coaching table has about 60k records in it and anytime I run the flow, it's only pulling the same records (I was just testing with top count 5, then did 20 but still pulls the first few records the same, even though the hire date is no longer blank)
Hi @jcastr02
As I understand, and to improve your worflow execution time, you should do the following:
1) Query coaching table where Hire Date is null
2) For each item in the coaching table where Hire Date is null
3) Query the Matrix table (list) using the employee ID (you will get only 1 item)
4) Update the coaching table with the Hire Date.
Hope it helps!
Ferran
Share
Report
All responses (
Answers (
