Flow to populate look up field based on text field
I am working on 2 entities. 1st is Contact (Renamed as Donor) and 2nd is Orders (Renamed as Donation).
On Donation entity form, I have a system mandatory look up field called “Potential Customer” and text field “Email Address”. I want to populate Potential Customer field value based on Email Address set. This operation will look for email address from contact entity and return the customer name to Potential Customer Field.
I have followed above steps but seems to something missing. Thanks in advance.
@bhitchlockfcs : You are right, there are multiple records exist with same email address. As one donor can donate on number of occasions and many are recurring donors. So, with the help of this flow we need to assign Contact based on email address as a unique record for data analysis purpose i.e., How much donation particular donor donated so far, etc.
With regards to Array, I am not sure how to write code as I am not technical person if you can enlighten me please.
Use the Initialize Variable action to create a variable of type array.
In the No branch you create an Append to Array action and in the Value add the reference to the current record.
At the very end add a Compose action and insert your array variable (if you want to see the result in the flow run) or add a Send Email action and put the variable in the body. It will be ugly but at least you can see which items had multiple results.
Have you looked at merging the duplicate records? That would eliminate the issue of choosing which one to link