I have a two SharePoint list 1 list has all the Data and second list where user input the computer name. I want to create a flow which will look for a specific computer name in anohter list and grab other information into another list. for example User name and email address.
Solved! Go to Solution.
Hi @Anonymous,
There should be a common value between the two lists. For example, Service tag.
Then when an item is created in List2, get items from List1. Then use a Condition to check if they have the same Service tag, if yes, update item using the corresponding dynamic content.
Please have a try with it.
Best regards,
Mabel Mao
Can you provide a little additional information please?
I understand you to say this:
1) You have a list with information about a computer including computer name.
2) You have a second list where one of the fields is computer name
3) When an item is saved in the second list, you want to lookup the computer name in the first list. Once you find it, you want to select olther columns in the first list and update the item in the second list.
Am I correct?
Please post here and I will create an example.
Scott
Yes. that is correct. I have attached the image below so that way you can get more ideas
In the second list it need to be update with the Display Name, User ID, Location.
Hi @Anonymous,
There should be a common value between the two lists. For example, Service tag.
Then when an item is created in List2, get items from List1. Then use a Condition to check if they have the same Service tag, if yes, update item using the corresponding dynamic content.
Please have a try with it.
Best regards,
Mabel Mao
Can you share screenshots of your workflow if it worked successfully?
User | Count |
---|---|
99 | |
38 | |
27 | |
23 | |
16 |
User | Count |
---|---|
130 | |
52 | |
48 | |
36 | |
24 |