Combine a list column with a lookup column
I have two SharePoint online lists that are connected with a lookup.
Client list – specific information on a client for an event; Client name, address, etc.
Event List – This has fields for the events that occur, and also LOOKUP fields, displaying the Client name, address and such in various lookup fields. They display just fine in the Event list, so that much is working.
I actually wanted to display content from the source list (Client) in a field on the destination list (Event, the list that has the lookup columns), and concatenate them so they are a single field. Then it will go into a PowerApps app as a single field, to lookup list items from these several source fields (Event name, Client Name, etc). I can display the lookup data in a PowerApps field in the Canvas app, but since it is only displayed and not actually in the field, PowerApps will not let me look up data in that lookup part of the field. (BTW, if you have a solution for that, I’d like to hear about it.)
So now I’m trying to combine the fields on the SharePoint side, and then display that combined field in PowerApps. In SharePoint, I have a calculated column with a formula that grabs the event data in that list (Event), but in the “Insert column” box, it does not display any of the lookup fields in the Events list the fields that are looking up data from the Client list. So I’m stuck on this side too. Is there a way in SharePoint to combine list fields in one table and also include list fields from a related table?
In another application–like Power BI–I would probably use something like the RELATED() or RELATEDTABLE() function, but I don’t know of anything like that in SharePoint.
I have two SharePoint online lists that are connected with a lookup. Client list – specific information on a client for an event; Client name, address, etc.Event List – This has fields for the events that occur, and also LOOKUP fields, displaying the Client name, address and such in various lookup fields. They display just fine in the Event list, so that much is working.I actually wanted to display content from the source list (Client) in a field on the destination list (Event, the list that has the lookup columns), and concatenate them so they are a single field. Then it will go into a PowerApps app as a single field, to lookup list items from these several source fields (Event name, Client Name, etc). I can display the lookup data in a PowerApps field in the Canvas app, but since it is only displayed and not actually in the field, PowerApps will not let me look up data in that lookup part of the field. (BTW, if you have a solution for that, I’d like to hear about it.)So now I’m trying to combine the fields on the SharePoint side, and then display that combined field in PowerApps. In SharePoint, I have a calculated column with a formula that grabs the event data in that list (Event), but in the “Insert column” box, it does not display any of the lookup fields in the Events list the fields that are looking up data from the Client list. So I’m stuck on this side too. Is there a way in SharePoint to combine list fields in one table and also include list fields from a related table?In another application–like Power BI–I would probably use something like the RELATED() or RELATEDTABLE() function, but I don’t know of anything like that in SharePoint. Read More