News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Filling out empties wi...

Power Automate - Building Flows

Unanswered

Filling out empties with information from another SP table

(0) Share

Report

Report

Posted on by jcastr02

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) Screenshot 2021-11-01 121050.png

All responses Img

All responses (1)

Answers Img

Answers (0)

fchopo 7,968 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filling out empties with information from another SP table

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans