Hello,
I'm trying to build a simple flow which would send out invoices automatically to customers from share mailbox. For this I have:
1) an excel file stored in SharePoint containing invoice numbers and customer emails;
2) Folder in SharePoint where invoice files (in pdf format) are stored. Name of the invoice files always is "Invoice number.pdf"
The logic I tried to use for a flow is as follows:
1) Manually trigger a flow;
2) List rows present in a table;
3) Apply to each;
4) Get file content using path;
5) Condition
6) Send an email from a shared mailbox.
But the issue I have is with "Get file content using path" action. Since the invoice file which needs to be sent out depends on the invoice number mentioned in excel I tried to use the dynamic content inside the path (/Shared Documents/Send out invoices/Invoices/@{items('Apply_to_each')?['INVOICE NUMBER']}.pdf) but it doesn't work and I keep getting errors when try to test the flow. I remember previously building a similar flow and then I used additional action "Build file path" before "Get file content using path" and it worked perfectly, but this "Build file path" action is not available anymore, so I do not know how to fix the error. I also tried to use the "Compose" action to build a file path and also tried to add a file path in the excel as a separate column, but it still doesn't work, so I'm running out of options. Hope somebody can help.
Thanks a lot in advance!
