Lookup Concat Two SharePoint Lists

[Anonymous]

Hello,

I have two lists:

List1:

Stores names and emails line-by-line

List2:

Stores names and emails, but emails are concatenated into single cells.

See example data:

I would like to update list2 each time an email is added or subtracted within list1. I have seen solutions using Power Apps but have been unable to replicate the result. I have been able to connect both lists into Power Apps, setup gallery's for each, but now am struggling to setup the code on list1 for Items.  I am fairly new to Power Apps, so any/all help would be much appreciated.

Thanks,

Joel

[Anonymous]

Thanks Randy!

However, I am still getting errors on the last line of code:

Email: Concat(_item._data, Email & ";")

The error on Concat talks about expecting an operator such as +,*,&. Then, there is an error on the ";" term stating that the formula contains "CurlyClose" where ";" is expected.

Again, I'm not very familiar with Power Apps syntax. So, I really appreciate the help.

[Anonymous]

Hey Randy,

Any update on this?

Thanks,

Joel

[RandyHayes]

@Anonymous 

He Joel - sorry for the delay...

Can you send me a screenshot of the entire formula in the formula editor with the red underlines showing the error?

[Anonymous]

Not a problem! Please see below screenshot + code.

With({_items: GroupBy('GWP Email Contacts', "Title", "_data")},
    Patch('GWP Distributor List',
        ForAll(_items As _item,
            {ID: LookUp('GWP Distributor List', Title = _item.'Distributor Taxonomy Group', ID)
             Email: Concat(_item._data, Email & ";")
            }
        )
    )
)

[RandyHayes]

@Anonymous 

Typo - Missing a comma!!

Formula should be:

With({_items: GroupBy('GWP Email Contacts', "Title", "_data")},
    Patch('GWP Distributor List',
        ForAll(_items As _item,
            {ID: LookUp('GWP Distributor List', Title = _item.'Distributor Taxonomy Group', ID),
             Email: Concat(_item._data, Email & ";")
            }
        )
    )
)

[Anonymous]

Now, it seems I am getting all sorts of other errors. See screenshot:

With({_items: GroupBy('GWP Email Contacts', "Title", "_data")},
    Patch('GWP Distributor List',
        ForAll(_items As _item,
            {ID: LookUp('GWP Distributor List', Title = _item.'Distributor Taxonomy Group', ID),
             Email: Concat(_item._data, Email & ";")
            }
        )
    )
)

[Anonymous]

Again, the end goal is to update the GWP Distributor List SharePoint list whenever the GWP Email Contacts list is updated.

[RandyHayes]

@Anonymous 

If you are getting that error, then it means that either your column names are not correct (ID or Email) or you are not providing the proper data to them.  

Check the column names first.  You need to specify the real column name of the column.  You will need to look at your SharePoint list definition to get that.  I suspect Email is not really Email.

To determine a column's real name, you can click on the column in the List Settings of your list and then in the address bar of your browser, look at the end of the URL - it will show the real name...that is what you need in the formula.

[Anonymous]

Data sources:

I did notice the email name was incorrect in my GWP Distributor List. So, I fixed that. However, now I am getting this error:

Any ideas?

[RandyHayes]

@Anonymous 

Where are you putting this formula??  What is the action and control you are putting it in?