User Profile
WillBee333
Copper Contributor
Joined Dec 19, 2022
User Widgets
Recent Discussions
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.422Views0likes0CommentsRenamed OneNote tags do not rename in the Web/Teams version
I mostly use the OneNote app in Teams. There are some things that are not available there nor in the web app. For example, you can rename tags only in the OneNote Desktop interface (which is fine); the "Discuss with <Person A>" of course expects "<Person A>" to be replaced with a person's name. But when I return to OneNote in Teams the tag is not renamed. I tried stopping OneNote and restarting it, restarting Teams, restarting the computer; none of these solves the problem. Is there a way to make a renamed tag cross over from the Desktop app to the browser or Teams interface?507Views0likes2Comments
Recent Blog Articles
No content to show