Forum Discussion
Hide List column based on another list of values
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 -...
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
