Hi, I am trying to write a flow on a Sharepoint list which has looks up fields referencing two other sharepoint lists and am getting the following error when trying to save the workflow.
Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The required field \"Project\" data type is not supported\r\nclientRequestId: 80014255-08db-43e0-b440-06e5a8bef106\r\nserviceRequestId: 80014255-08db-43e0-b440-06e5a8bef106" }'.
First question - I assume that Automate can handle lookups to multiple other lists and is not limited to one?
My scenario is:
Process Governance list - has look up to Master Project list, and also has fields to look up Master Process list.
All the flow has atm is this
and the error occurs when trying to save at this point.
The field that is being referenced in the error message 'Project' lives on a master list and is not a required field on that list. It may or may not be blank on the master list depending on other fields in the master list.
The child list "Process Governance" has a look up field "Project" which is a required field and looks up to the Project field in the master list
The Master Process list does not contain a Project field at all.
I am a bit confused by the error message as it references the data type
The required field \"Project\" data type is not supported\
Hope this is not too confusing
Thanks
