Share
ReportHello All,
Hope you are doing well. I need help to figure this out.
I have 2 SharePoint list.
List A:
| Manager ID | Name | Grade | Status |
| 1 | Oswald | 10 | Offshore |
| 2 | Rayner | 10 | Lab |
| 3 | Simba | 10 | Office-base |
| 4 | Alfie | 13 | Office-base |
| 5 | Lee | 9 | Lab |
| 6 | Wayne | 9 | Offshore |
List B:
| Employee ID | Manager ID | Status |
| 1 | 4 | |
| 2 | 4 | |
| 3 | 3 | |
| 4 | ||
| 5 | 1 |
Once a day, I want to build a flow that will compare the manager id from of the list and automatically input the column status in List B from List A base on the manager ID as a key or reference, except for those in List B that have 'blank' manager ID.
Please guide me on building this flow.
Thank you in advance!
Categories:
I have the same question (0)
All responses (
Answers (
262
