SOLVED

Connections in webpart to filter values in a library webpart

%3CLINGO-SUB%20id%3D%22lingo-sub-828469%22%20slang%3D%22en-US%22%3EConnections%20in%20webpart%20to%20filter%20values%20in%20a%20library%20webpart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-828469%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20SharePoint%20Users%2C%3C%2FP%3E%3CP%3EI've%20a%20Task%20list%20and%20a%20library%20web%20part%20in%20a%20page.%20The%20task%20list%20has%20a%20field%20DocId%20which%20is%20populated%20with%20the%20ID%20of%20Library.%20A%20flow%20creates%20task%20in%20the%20Task%20list%20and%20links%20the%20DocId%20with%20the%20value%20from%20the%20library.%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20the%20connection%20feature%20for%20the%20task%20list%20webpart%20to%20filter%20the%20library%20document.%3C%2FP%3E%3CP%3EThis%20doesn't%20filter%20the%20results%20in%20the%20library%20web%20part.%3C%2FP%3E%3CP%3EThe%20DocId%20is%20a%20number%20field.%20If%20the%20issue%20is%20with%20incompatible%20field%20types%2C%20is%20their%20a%20workaround%20for%20this.%3C%2FP%3E%3CP%3ECan%20anyone%20help%20me%20here.%3C%2FP%3E%3CP%3EAttached%20the%20screenshots%20which%20can%20help%20in%20understanding%20the%20requirement.%3C%2FP%3E%3CP%3ET%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129044i6331695C4006CCAB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Connections%20for%20task%20list.png%22%20title%3D%22Connections%20for%20task%20list.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129043i313DD9A37F7DAB0D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22DocId%20field%20in%20Task%20List.png%22%20title%3D%22DocId%20field%20in%20Task%20List.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F129042i2827EE8B36EC81B7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Library%20webpart.png%22%20title%3D%22Library%20webpart.png%22%20%2F%3E%3C%2FSPAN%3Ehanks%2C%3C%2FP%3E%3CP%3EKevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-828469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-835710%22%20slang%3D%22en-US%22%3ERe%3A%20Connections%20in%20webpart%20to%20filter%20values%20in%20a%20library%20webpart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-835710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F268367%22%20target%3D%22_blank%22%3E%40kevingeorget%3C%2FA%3E%26nbsp%3BI%20replicated%20the%20same%20it%20worked%20for%20me%20in%20the%20second%20time.%20The%20one%20thing%20I%20did%20wrong%20in%20the%20first%20time%20I%20kept%20the%20DocID%20as%20text%20instead%20of%20number%20and%20it%20did%20not%20worked%20for%20me.%20SO%20I%20changed%20the%20DocID%20to%20Number%20and%20it%20worked.%20Please%20check%20below%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130012i3002B9B1C4AC4DBB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20the%20setting%20I%20used%20for%20the%20DocID%20number%20column%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130013i74C578799658E9E2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20also%20please%20find%20the%20setting%20for%20the%20web-part%20connection%20and%20I%20am%20sure%20you%20might%20have%20selected%20the%20connection%20type%20as%20well%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130017i04C4BB09600BE90A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_6.png%22%20title%3D%22clipboard_image_6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130015iED829847A4822AE3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_4.png%22%20title%3D%22clipboard_image_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%20Reach%20out%20to%20me%20for%20any%20queries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi SharePoint Users,

I've a Task list and a library web part in a page. The task list has a field DocId which is populated with the ID of Library. A flow creates task in the Task list and links the DocId with the value from the library.

I'm trying to use the connection feature for the task list webpart to filter the library document.

This doesn't filter the results in the library web part.

The DocId is a number field. If the issue is with incompatible field types, is their a workaround for this.

Can anyone help me here.

Attached the screenshots which can help in understanding the requirement.

 

TConnections for task list.pngDocId field in Task List.pngLibrary webpart.pnghanks,

Kevin

 

1 Reply
Best Response confirmed by kevingeorget (Contributor)
Solution

@kevingeorget I replicated the same it worked for me in the second time. The one thing I did wrong in the first time I kept the DocID as text instead of number and it did not worked for me. SO I changed the DocID to Number and it worked. Please check below:

clipboard_image_1.png

This is the setting I used for the DocID number column:

clipboard_image_2.png

Then also please find the setting for the web-part connection and I am sure you might have selected the connection type as well:

clipboard_image_6.png

 

clipboard_image_4.png

 

I hope this helps. Reach out to me for any queries.