Hello,
I am using MS Form to create a submission to a SharePoint list. I want to add validations in the power automate to check if the File File # value from MS Forms already exists in the SharePoint List column "Firm File #".
I am getting an error in the Get Items action. I have added an expression in the Filter Query "'FirmFile_x0023_ eq {{triggerBody()?['File File #']}}'". I am receiving an error message saying" The expression "''FirmFile_x0023_' eq {{triggerBody()?['File File #']}}'" is not valid. Creating query failed. clientRequestId: f6b5b205-bd57-47af-8309-face8a943696 serviceRequestId: f6b5b205-bd57-47af-8309-face8a943696
I think the issue is with the name of the sharepoint list field name.
Here is my flow:
- When a new response is submitted
- Get Response details
- Get Items
@abm