cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power_Aissam
Level: Powered On

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
Community Support Team
Community Support Team

Re: Connecting 2 sharepoint lists using flow

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.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Connecting 2 sharepoint lists using flow

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.

 

Power_Aissam
Level: Powered On

Re: Connecting 2 sharepoint lists using flow

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
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 82 members 3,988 guests
Please welcome our newest community members: