when an excel column(Type) is connected to drop down card in Power apps , and the other column(A,B,C,D,E) have the values populating dynamically in the text input cards.
Now, the issue I am facing is that I am unable to hide them based on the Job code drop down(Refer Power apps Snapshot below)


I have connected type to the dropdown , I am dynamically getting values in A B C D E columns if I change dropdown values
My requirement is that based on job code type values Columns has to be hidden. The visible component is not working.
for example if QC-IQ-01 then i should see only A,B cards in the power apps, but when i tried using below formula it's not working.
Any kind of help or work around is appreciated.
Thanks.
