Is there an easier (no code, no plugin) way to test if a date from one list falls among the date on another list? (so essentially checking if a date = holiday)
I tried lookup column but this is insufficient. Thanks for the help!
2
-
Use data view web part to filter data in one list based on the data in another list SharePointsan– san2017-12-14 02:56:50 +00:00Commented Dec 14, 2017 at 2:56
-
sharepoint.stackexchange.com/questions/210504/…san– san2017-12-14 03:00:21 +00:00Commented Dec 14, 2017 at 3:00
Add a comment
|
1 Answer
To achieve this, you can set second list data view web part to get parameter from first list, then filter the second list based on the parameters get from first list, try the following steps:
Insert two web part zone, then insert data views for first list and second list.
For the second list data view web part, in Common Data View Tasks, choose Web Part Connections.
Set the Web Part Connections as below:
choose the action on the source web part to use for this connection: Get Parameter From
choose Connect to a Web Part on this page
set choose the columns in the source web part which match the input parameters for the target web part: column in first list: field1 input to second list: paramenter1, column in first list: field2 input to second list: parameter2
In Common Data View Tasks, set filter for second list, filter the field in second list based on the conditions and parameters.
-
Hi, I am trying to see if a date is a holiday (returning a yes/no) Thank you for your efforts but your answer only filters/provides view; not a decisionDingo– Dingo2017-12-14 14:34:56 +00:00Commented Dec 14, 2017 at 14:34