Filtering a data table gallery by dropdown

%3CLINGO-SUB%20id%3D%22lingo-sub-2183007%22%20slang%3D%22en-US%22%3EFiltering%20a%20data%20table%20gallery%20by%20dropdown%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2183007%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20experiencing%20issues%20trying%20to%20filter%20my%20data%20table%2Fgallery%20by%20my%20dropdown.%20The%20data%20is%20from%20SharePoint.%20I%20was%20successfully%20able%20to%20create%20the%20dropdown%20and%20includes%20the%20choices%20I%20want%20from%20the%20'Issue%20Status%20-%20UDAIP%20Teams%20Only!!'%20column%20(shown%20on%20the%20table%20as%20%22Status%22%20but%20this%20is%20its%20real%20name%20from%20SharePoint)%20but%20when%20I%20input%20the%20formula%20as%20seen%20at%20the%20top%20of%20photo%202%20it%20will%20not%20show%20any%20data%20when%20I%20select%20any%20of%20the%20dropdown%20choices.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdditional%20info%3A%20My%20dropdown%20is%20called%20Dropdown1%3C%2FP%3E%3CP%3EMy%20form%20is%20titled%20'UDAIP%20Issue%20Tracker%201_1'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20what%20I'm%20doing%20wrong%20with%20the%20formula.%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%20image-alt%3D%22IssueTrackerImage1.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260683i6E94ABF111F7D9B2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22IssueTrackerImage1.jpg%22%20alt%3D%22IssueTrackerImage1.jpg%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22IssueTrackerImage2.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F260684i8DF0F9A14E02848C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22IssueTrackerImage2.jpg%22%20alt%3D%22IssueTrackerImage2.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2183007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello.

 

I am experiencing issues trying to filter my data table/gallery by my dropdown. The data is from SharePoint. I was successfully able to create the dropdown and includes the choices I want from the 'Issue Status - UDAIP Teams Only!!' column (shown on the table as "Status" but this is its real name from SharePoint) but when I input the formula as seen at the top of photo 2 it will not show any data when I select any of the dropdown choices.

 

Additional info: My dropdown is called Dropdown1

My form is titled 'UDAIP Issue Tracker 1_1'

 

Please let me know what I'm doing wrong with the formula.

 

IssueTrackerImage1.jpgIssueTrackerImage2.jpg

0 Replies