SharePoint – Search for invoice number in list and send file as email attachment

Questions
1

What are you trying to achieve?

SharePoint – Search for invoice number in list and send file as email attachment

Steps taken so far

Hello everyone,

I am currently building a scenario where I pass an invoice number from Power Automate → Webhook → Make.
In Make I would like to:

Search a SharePoint list for this invoice number.

Find the corresponding list item (column “InvoiceNumber”).

Retrieve the invoice file (PDF / attachment) linked to that item.

Download the file and send it via Outlook email as an attachment.

I have already tested the modules Get an Item and List items.

With “Get an Item” I have to provide an Item ID – but I don’t have that, I only want to search by invoice number.

With “List items” I get the following error:

Validation failed for 1 parameter(s).
Invalid number in parameter ‘limit’.

Even though I set the limit to 1.

:backhand_index_pointing_right: My questions:

What is the correct way to find a list entry by a specific field (Invoice Number)?

How do I properly use the OData filter query to search by this field?

And how can I get the attached PDF file from the result so I can use it as a binary in the email step?

Thanks a lot for your help!

Best regards,
Torsten