Feb 02 2022 01:50 PM - edited Feb 02 2022 02:41 PM
Feb 03 2022 12:33 AM
@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
Feb 03 2022 02:33 AM