Hi,
I have a SharePoint List that lists each product name and each customer contact separately, with view tabs "Customers" and "Products" to keep them displayed separately.
Customer's names are listed under the [CONTACT] column, which is a "single line of text" column. For each [CONTACT] entry, there is a "lookup" column that references the [PRODUCT NAME] column, called [CUSTOMER'S PRODUCT]. Under [CUSTOMER'S PRODUCT], the product name is chosen from the lookup column for which the contact is a customer.
The [PRODUCT NAME] column is a "single line of text" column.
I want to create a new column, called [CUSTOMERS] that automatically compiles a list of customers for each product. As in, "IF [PRODUCT NAME]=[CUSTOMER'S PRODUCT], THEN [CUSTUMERS]=[CONTACT 1]; [CONTACT 2]; [CONTACT 3]..."
Is this possible via Power Automate?
Just to summarize:
[CONTACT] = "single line of text" column
[PRODUCT NAME] = "single line of text" column
[CUSTOMER'S PRODUCT] = "lookup" column that references the [PRODUCT NAME] column
[CUSTOMERS] = IF [PRODUCT NAME]=[CUSTOMER'S PRODUCT], THEN [CUSTUMERS]=[CONTACT 1]; [CONTACT 2]; [CONTACT 3]...
Thanks for your help!
