Share
Report
90I'm trying to build an automated flow to update one SharePoint list with another SharePoint list but having some trouble matching records. This should be pretty normal: get items for all the records in the master list, apply to each, get items for the list to be used to update the master. The match is on three fields: state, program, and project name.
The two lists are roughly the same same size, approximately 150 records. The plan is if the records match, update the master with the contents of the new list, if there is no match, create a new master from new. The columns in both files match.
On the 116th record I get the following error:
The expression "(Program_x0020_Project_x0020_Name eq 'PIFR Runnin's River WS')" is not valid. Creating query failed.
clientRequestId: 4754eb76-70a6-455f-9571-07f8a8369130
serviceRequestId: 4754eb76-70a6-455f-9571-07f8a8369130
I have tried several things to fix this or narrow the problem:
1. Removing the ODATA filter for program name but leaving state and program, and the flow runs successfully.
2, Copied the field from it's current name to another name to remove the internal name in the message and use a column name that has not been changed. No joy on that one though I thought it might help.
3. Copied the program name from the master to the new. Though they look the same, I wanted to eliminate the possibility I wasn't seeing something. Had this work in another app where I was trying to match an email to the ms network email. No joy here either.
Any insight would be appreciated.
Carter
All responses (
Answers (
