Good Day,
I am busy with a flow where after invoice data has been extracted from a invoice, I need to check if the "Vendor Name" exists on a "Vendor Name" SharePoint list. If it does, the invoice can proceed to be written to record and needs to also have a Unique Vendor ID appended too it (also available on the SharePoint List), if it does not, then a e-mail needs to be sent to the company who sent the invoice advising that they are not on the vendor list.
I have managed to successfully test when the scenario above is True (Vendor Name DOES exist on SP List).
However have the following two challenges:
- When the Vendor Name does NOT exist on the SP List it returns a blank output [] - See images. I have tried creating a expression: empty(value('Apply_to_each')?['Title']) too address this in a condition? But despite my best efforts I can never get the FALSE scenario e-mail to fire (even though I'm told the process has run successfully.
- When the Vendor Name is found and the scenario is True, I have no idea how to now save the Invoice information to a list and append the Unique Vendor Number too this newly created record?
Any assistance would be greatly appreciated.
Kind Regards,


Report
All responses (
Answers (