Hide List column based on another list of values

%3CLINGO-SUB%20id%3D%22lingo-sub-3107836%22%20slang%3D%22en-US%22%3EHide%20List%20column%20based%20on%20another%20list%20of%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3107836%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20conditionally%20format%20a%20column%20in%20a%20list%20if%20the%20value%20is%20not%20present%20in%20a%20separate%20list%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI.e%20the%20full%20requirement..%3CBR%20%2F%3E%3CBR%20%2F%3E-%20I%20have%20a%20list%20of%20users%20called%20Access_list%20column%20%3DUser%3CBR%20%2F%3E%3CBR%20%2F%3E-%20In%20the%20main%20list%20Report_Gallery%20I%20am%20using%20for%20my%20gallery%20view.%3CBR%20%2F%3E-If%20the%20logged%20in%20user%20is%20in%20the%20Access_list%20I%20want%20to%20show%20a%20button%20with%20a%20url%20link%20to%20an%20output%3CBR%20%2F%3E-If%20not%20in%20the%20Access_List%20show%20a%20button%20%22Request%20Access%22.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20only%20bit%20I%20can't%20work%20out%20is%20to%20conditionally%20check%20if%20the%20logged%20in%20user%20is%20in%20a%20separate%20list%20in%20this%20case%20%3D%20Access_List%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20appreciated%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3107836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Is it possible to conditionally format a column in a list if the value is not present in a separate list?

I.e the full requirement..

- I have a list of users called Access_list column =User

- In the main list Report_Gallery I am using for my gallery view.
-If the logged in user is in the Access_list I want to show a button with a url link to an output
-If not in the Access_List show a button "Request Access".

The only bit I can't work out is to conditionally check if the logged in user is in a separate list in this case = Access_List

Any help appreciated
Thanks
2 Replies

@AndyFisher you would need to run a flow in Power Automate with the trigger "when an item is created or modified", loop through the other list with a get items filter query based on the user email and then have a condition that runs with a "configure after"  the get items is both successful and failed. If it's successful update the column in your first list with the link, if failed update the list with the Request Access link. A bit fiddly.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thanks Rob
Will give something like that a spin
Cheers
Andy