I’ve set up a Zap in Zapier that follows this flow: (1) get a file from SharePoint, (2) extract the file number from its name, (3) use that number to find the matching item in Monday.com, and (4) upload the file to that item. When I use a static item ID, the upload works correctly. However, when I make the lookup dynamic, so Zapier uses the extracted file number to identify the corresponding Monday.com record, the Zap fails. I double-checked the logic with ChatGPT and Copilot, and everything looks correct on paper, but it simply doesn’t work in practice. I’d appreciate any help in figuring out what’s causing the lookup/upload step to fail.
Summary: Get file from SharePoint → 2. Extract file number → 3. Find matching item in Monday.com → 4. Upload file to that item





