How to place a condition to update column in SharePoint list after AI Builder has extracted data from handwritten form

(0) Share

Report

Posted on by AVFC

147

Hello

I have a flow which extracts data from a handwritten form sent in via email using "extract info from documents" AI Builder and uploads into a SharePoint list (this works fine as below). I have tried placing a condition after the SharePoint "create item" as below to say if service name contains west avenue then update the service name column with the text C11. I wasn't sure where i was supposed to be placing the C11 so put it into Update Item SharePoint action. The problem is even though the service name contains the words west & avenue the condition always returns false. Do i need to firstly use a "get items" SharePoint action after the create item before i use a condition? Also should i be using the SharePoint action of "Update Item" when setting the new value?

Many Thanks

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (1)

Sort by

AVFC 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Apologies if the above is a bit ambiguous. Can elaborate more if needed?

Was this reply helpful? Yes No
Verified answer

AVFC 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Just doing some testing to see if i can get the condition to return true but it keeps returning false. I've tried the below using the service name from the AI builder output and also the service name from the Create Items output but both return false. Where am i going wrong?

This is now resolved as i was using a lower case w in the condition but the AI had only extracted a capital W so that's why it returned false.

Was this reply helpful? Yes No