
Announcements
Hello there,
I have an idea for a flow but am unsure of how to proceed with it. The idea is as follows: There are two tables, Items and Users. When an item is created in the Items List, there is an email address column that is blank by default. I want to populate this email address with the email of a specific user in the Users List by a specific identifier (non numeric, it's a choice value) which is in a choice column.
I assume the logic would go: Trigger when item is created -> get Users List -> Lookup User identifier -> get User (ms365 profile, includes email) -> populate email column in Items List.
I just don't know what this would look like as a flow in terms of functions and the contents inside. Any guidance at all is much appreciated!