Unanswered

Creating file in Sharepoint by querying file name in excel table

(1) Share

Report

Posted on by tradestorm12

Hello Everyone,

I'm trying to setup a Power Automate flow that saves down a PDF to Sharepoint every time it arrives in a shared mailbox.

But I would like it to query an excel table for the file name. So for example it would use the sender address to find the customer account number in the table then save the file down using the account number as the name

I've got the saving down of the PDF working but I can't figure out how it would query an excel table using the sender address. I've had a few goes at it but can't see to get it.

Has anyone got any examples?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@tradestorm12

Use the List rows in a Table action to query the excel document.

Use the Sender's email to filter the row and store the account number in a variable.

You could then use the variable to name your file.

Let me know if you run into issues.

Was this reply helpful? Yes No
tradestorm12 8 on at

Like (0)

Report

Thank you Sudeep for the response,

Are you able to provide a screenshot of the flow as an example?

This would help me to better replicate on my end then test.

Thank you 🙂

Was this reply helpful? Yes No