Power Platform Community Forum Thread Details

I'm fairly familiar with SharePoint but struggling with something and searches, although result in a close match, I'm not able to hit upon a solution.

I've two lists. List 1 is Leads and List 2 is Suppliers. Both lists are custom lists.

Leads (list 1) has a lookup value for Suppliers and pulls information across should the item pre-exist in Suppliers (list 2). What I'm trying to do is when the Supplier does not exist, and entered on new/edit form in Leads (List 1), that an entry is then automatically created in Suppliers (list 2).

I've seen something similar but refers to Excel files rather than a SharePoint list.

I think the flow is fairly straight forward, i.e. For Selected Item (list 1), Get Item (from list 1), Create Item (list 2). The Get Item only seems to allow me to pull back [Id] rather than the value entered. Any thoughts or pointers to previous solutions?

Thanks

Categories:

General topics