Hello,
New to Power Automate/SharePoint and Power Apps - enjoying learning - but Im stuck!
I have a SP list (maintenance requests) that users can add to from a Power app. When the user creates an item, or maintenance update an item notifications are sent as needed - all working great (currently email notifications).
I am stuck with what seems a simple problem I hope someone can help me with.
I have a second list (NotificationSettings) that holds records of if user wants to receive an Email or app notifications or both.
User (person/Group) | WantsEmail (Y/N) | WantsNotification (Y/N)
My problem:
In my 'When an item is created' flow of the 'Maintenance requests' (list 1) flow, I need to check the users preference in the NotificationsSettings (list 2).
i.e.
When List 1 item is created
If 'Maintenance User' wantsEmail = true (in List2) then InitialiseVar wantsEmail = true
If 'Maintenance User' wantsNotification = true (in List2) then InitialiseVar wantsNotification = true
Carry on in flow from List 1 item creation
Can someone help me with how I get an item from a second list to use in a flow triggered by the creation of an item in a different list
Thanks
Solved! Go to Solution.
So I resolved this after further reading:
for anyone looking for help on this I used 'Get items' connected to the second list, and filtered using Username/Email er 'Created by Email' where Username is my person/group column name.
So I resolved this after further reading:
for anyone looking for help on this I used 'Get items' connected to the second list, and filtered using Username/Email er 'Created by Email' where Username is my person/group column name.