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.

 

View solution in original post

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.

 

View solution in original post

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

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,856)