SharePoint Dynamic Filter doesn't work when filter is used.

%3CLINGO-SUB%20id%3D%22lingo-sub-2060158%22%20slang%3D%22en-US%22%3ESharePoint%20Dynamic%20Filter%20doesn't%20work%20when%20filter%20is%20used.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060158%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3EI%20had%20an%20issue%20with%20SharePoint%20Dynamic%20Filter%20function.%3C%2FP%3E%3CP%3EHere%20is%20my%20story%3A%3C%2FP%3E%3COL%3E%3CLI%3EI%20have%20created%20two%20lists%20(List_A%20and%20List_B)%3B%3C%2FLI%3E%3CLI%3EI%20have%20added%20these%20two%20lists%20as%20two%20web%20parts%20on%20a%20SharePoint%20page%3B%3C%2FLI%3E%3CLI%3EThen%20I%20applied%20dynamic%20filter%20using%20one%20shared%20column%20from%20these%20two%20lists%20and%20it%20works%20good.%20Meaning%3A%20when%20I%20select%20one%20item%20in%20List_A%20and%20List_B%20will%20only%20show%20items%20related%20to%20the%20item%20I%20selected%20in%20List_A.%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CP%3EMy%20issue%20is%3A%3C%2FP%3E%3CP%3EWhen%20I%20apply%20any%20filter%20in%20List_A%2C%20and%20then%20select%20any%20item%20from%20the%20filter%20result%20of%2C%20then%20the%20Dynamic%20Filter%20would%20not%20work%20in%20List_B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20help%20to%20provide%20a%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2060158%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2353602%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Dynamic%20Filter%20doesn't%20work%20when%20filter%20is%20used.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2353602%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928809%22%20target%3D%22_blank%22%3E%40Natasha2020%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3EI%20have%20the%20same%20basic%20issue.%20If%20you%20simply%20select%20an%20item%20in%20List_A%20in%20your%20example%2C%20List_B%20or%20in%20my%20case%20using%20an%20Embeded%20Webpart%20connecting%20to%20List%20A%20works%20fine.%20I'm%20using%20it%20to%20bring%20up%20a%20Bing%20Map%20of%20a%20Latitude%20%2F%20Longitude%20location%20and%20also%20look%20up%20a%20Document%20Library%20and%20Photo's%20library%20for%20buildings%20at%20a%20location.%20The%20Controlling%20list%20has%20the%20required%20columns%20and%20like%20I%20said%2C%20just%20selecting%20an%20entry%20works%20fine.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20code%20I'm%20using%20for%20the%20Bing%20Maps%20is%20Microsoft's%20own%20example%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fconnect-web-parts-in-sharepoint-b457668c-d843-4b1b-8977-a6f9228a1dec%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fconnect-web-parts-in-sharepoint-b457668c-d843-4b1b-8977-a6f9228a1dec%3C%2FA%3E%3CBR%20%2F%3EHowever%20if%20I%20use%20a%20Filter%20By%20on%20a%20column%2C%20or%20a%20Group%20By%20on%20the%20list%20values%2C%20then%20the%20Dynamic%20Filtering%20or%20passing%20of%20Column%20Values%20to%20the%20Embeded%20Webpart%20does%20not%20work%20(with%20the%20exception%20of%20the%20original%20Title%20column%2C%20%24Title%20and%20any%20dynamically%20filtering%20that%20occurs%20using%20the%20original%20Title%20field%20(even%20if%20renamed)%20works%20on%20List_B%20or%20the%20Embeded%20Webpart).%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20basically%20the%20bug%20is%2C%20that%20all%20other%20Column%20Values%20(except%20%24Title)%20don't%20pass%20to%20the%20Dynamically%20Filtered%20Downstream%20items.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMicrosoft%20Support%2C%20can%20you%20please%20confirm%20this%20bug%20exists%20and%20work%20on%20fixing%20this%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20me%2C%20when%20I%20select%20the%20control%20list%20row%20(List_A%20in%20the%20above%201st%20post)%2C%20my%20Embeded%20Web%20Part%20in%20SharePoint%20modern%20simply%20errors%20out%2C%20VS%20what%20happens%20when%20no%20Filter%20is%20applied%20to%20List_A%20and%20you%20simply%20select%20a%20row.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Peter_Board_0-1620966106282.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280676i565B9E8B58BF8C3A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Peter_Board_0-1620966106282.png%22%20alt%3D%22Peter_Board_0-1620966106282.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Peter_Board_1-1620966213485.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280677iC365C04C8F69803D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Peter_Board_1-1620966213485.png%22%20alt%3D%22Peter_Board_1-1620966213485.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Guys,

I had an issue with SharePoint Dynamic Filter function.

Here is my story:

  1. I have created two lists (List_A and List_B);
  2. I have added these two lists as two web parts on a SharePoint page;
  3. Then I applied dynamic filter using one shared column from these two lists and it works good. Meaning: when I select one item in List_A and List_B will only show items related to the item I selected in List_A. 

My issue is:

When I apply any filter in List_A, and then select any item from the filter result of, then the Dynamic Filter would not work in List_B.

 

Can anybody help to provide a solution?

1 Reply

@Natasha2020 
I have the same basic issue. If you simply select an item in List_A in your example, List_B or in my case using an Embeded Webpart connecting to List A works fine. I'm using it to bring up a Bing Map of a Latitude / Longitude location and also look up a Document Library and Photo's library for buildings at a location. The Controlling list has the required columns and like I said, just selecting an entry works fine.

The code I'm using for the Bing Maps is Microsoft's own example
https://support.microsoft.com/en-us/office/connect-web-parts-in-sharepoint-b457668c-d843-4b1b-8977-a...
However if I use a Filter By on a column, or a Group By on the list values, then the Dynamic Filtering or passing of Column Values to the Embeded Webpart does not work (with the exception of the original Title column, $Title and any dynamically filtering that occurs using the original Title field (even if renamed) works on List_B or the Embeded Webpart).

So basically the bug is, that all other Column Values (except $Title) don't pass to the Dynamically Filtered Downstream items. 

Microsoft Support, can you please confirm this bug exists and work on fixing this? 

For me, when I select the control list row (List_A in the above 1st post), my Embeded Web Part in SharePoint modern simply errors out, VS what happens when no Filter is applied to List_A and you simply select a row.

Peter_Board_0-1620966106282.png

Peter_Board_1-1620966213485.png