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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,521)