I am attempting to update a secondary list after the primary list is updated using Flow. From time to time my projects (in the primary list) change agents and I need to update all permits with the new agents email address in the secondary list for that project number. The project list form is used to update the project data in SharePoint.
I have 2 lists. The first is the primary list called "Projects" , the secondary list is called "Permits".
Both the primary and secondary lists have several fields that are different however they include two that are the same, projectnumber & agentemail
The primary list has the field projectnumber as a unique value in SharePoint. The agentemail field only contains one email address.
The secondary list has multiple entries with the same projectnumber with the associated agentemail listed from the primary list.
As stated earlier, my goal is to update all matching projectnumber and agentemail entries in the secondary list that match the primary list when the primary list is modified.
Primary List (Before):
Secondary List (Before):
Secondary List Final Result (After primary list is updated with Wilma on project # 123, joe is no longer listed on the Permits - Flow):
That worked great. Since I changed the default Title column to projectnumber I needed to have the original field name in place as you pointed out. Thank you for the solution.
Sorry, I should have mentioned that you will need to replace the column name projectnumber with the correct name from your Secondary list. I tried to guess. I tested it in my development environment.
Replace projectnumber with the SharePoint's internal column name from your Secondary list. This can be found in the column settings screen, in the URL. An example is given below where the actual internal column name is StatusPMValue:
The reason why you are getting the error for the filter query is that you had renamed the SharePoint Title field to projectnumber - but its internal SharePoint name is still Title. I noted that your Secondary list is missing the default Title column - so you must have renamed it:
Ellis
Thank you for your interest. When I apply this solution I get a flow failure. It appears the filter suggested is not working properly. The error suggests that the column projectnumber does not exists however it clearly does in both lists.
This is the error:
This is the suggestion:
This is what was inputted into the flow.
This is the primary list showing the projectnumber field
This is the secondary list showing the projectnumber field
Suggestions?
The flow would resemble something like this:
We then update all the items we got from the Secondary list (stored in value) with the updated agent email address:
Here is a closer look at which columns are being used in the Update item action (click the image to view a larger version of the image):
Hope this helps.
Ellis