I have a Sharepoint list which gets populated automatically when a new answer is submitted to a form.
Now I would like a few additional customer details to be added to each new row in my sharepoint list. So I want to build an automation triggered by a new row in the main list, and with conditions so depending on the customer name in the new row, the right customer details are picked from another list and added to the main list.
is that possible? ( I do not have Dataverse)
I have spent the day trying to build such a flow, trying and find tutorials, asking co-pilot, but without luck.
I really hope someone in the community can help me!