cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PipManifold
Helper II
Helper II

On a reoccurring basis update all rows in excel table which meet criteria

Hi there

We run a tutoring program.  At the beginning of the semester we recruit our tutors who select up to 3 courses to tutor and then a 2 hour period to tutor in (either one 2 hour block or two 1 hour blocks)  this is put into a table with the following headings:

Tutor name

Course 1

Course 2 (optional)

Course 3 (optional)

Day 1

Time 1

Day 2 (optional)

Time 2 (optional)

Completed (we have confirmed with the tutor and can put in the timetable)

Timetabled (Auto set to no)

 

Once a staff member has filled out all the needed columns they mark the row as COMPLETED in the Completed column.

I then have a flow which creates rows in our Sharepoint timetable (1 to 6 rows, depending on the tutor’s selections) for any row which is marked as completed but not timetabled.

 

So I don’t have these entries recreating themselves day after day I want to write a flow which early the following morning, updates all the rows in my excel table marked completed to Timetabled=Yes, however, everything I try only updates the first value and does not update the rest.  Is there away to set up a loop or something.

 

Here is what I got so far:

Update all rows.PNG

Update all rows 2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @PipManifold ,

 

You need to enter the expression in the Key Value field as below:

item()?['Student number']

1.png 

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-alzhan-msft
Community Support
Community Support

Hi @PipManifold ,

 

You need to enter the expression in the Key Value field as below:

item()?['Student number']

1.png 

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (64,105)