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

Connecting 2 sharepoint lists using flow

Hi,

 

I am trying to build a task list app using powerapps. In my team, they set every last friday of the month as day -1 and the monday after as day 1. They have Workdays ranging from -5 to 20 depending on the month. I have created 2 sharepoint lists, the first one with all the fields needed for the tasks including a Workday  and a Due date field. And the second list is a basically a calendar for the whole year accounting for things like holidays etc, it has 3 fields: the month end which is Workday -1 aka last friday of the month, the Workday, and its corresponding Due date. What I want to do is once a Workday is inputted in the first list, my flow goes and filter the second list based on the Workday and the month end to find the corresponding due date. I have attached few pictures to illustrate what I am trying to say, but I am really out of ideas on how to build such a flow. I would apprecite any help!

 

Thanks,

image.png5.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Power_Aissam ,

 

You could create a flow with steps below:

1. Add trigger, when an item is created in the WorkList_Calendar.

2. Add action "Get items" to get all team from the Second list.

3. Add an "Apply to each" to get each items in the Second list.

4.Add a "Condition" to check the Workday in WorkList_Calendar and Workday in the Second list, if they are equals, fill in the Due Date column of the Second list with the "Due date" dynamic content from the trigger.

 

Please let me know if your problem could be solved.

 

 

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

2 REPLIES 2
v-alzhan-msft
Community Support
Community Support

Hi @Power_Aissam ,

 

You could create a flow with steps below:

1. Add trigger, when an item is created in the WorkList_Calendar.

2. Add action "Get items" to get all team from the Second list.

3. Add an "Apply to each" to get each items in the Second list.

4.Add a "Condition" to check the Workday in WorkList_Calendar and Workday in the Second list, if they are equals, fill in the Due Date column of the Second list with the "Due date" dynamic content from the trigger.

 

Please let me know if your problem could be solved.

 

 

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

Hi @v-alzhan-msft ,

 

Thanks for your reply.

This solution wouln't work for the following reasons:

1.  No items are being created in WorkList_Calendar list on a regular basis. The data is only uploaded once a year.

2.  Each month has the same workday values so the condition to check if they are equal wouln't be accurate because it would return dates in 12 months. For example Workday 5 in December and workday 5 in January.

 

Basically what I want is when an item is added to the second list (Task List), I want it to go find the Due Date value based on the Workday value in the WorkList_Calendar.

 

Best regards,

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 (51,853)