Power Platform Community Forum Thread Details

Validation check against a SharePoint list of Ai Extracted data

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,

Categories:

Form Processing

AI Builder

Quick Links