cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,323)