Is it possible to make a lookup column that looks up?
List called PeopleList with columns “Person” and “Title”. Workflow called “CopyPersonFromTitle”, which runs when an item is created/changed. A list called CustomListWithLookup, which has a Lookup with the following configuration.
When to use a lookup column in SharePoint?
SharePoint Lookup columns are very much helpful when you want to display data which are presented in a separate list. In the large enterprise, there are list data which may be related to another list in SharePoint Online or SharePoint 2013. In those cases lookup columns are ideal.
Can you change the type of an existing column?
You can’t change the type of an existing column. You will need to create a parallel column of type choice and then update each list item to copy the existing column value to the choice column. Once that is done you can delete the original column. Please remember to mark your question as ‘answered’ if this solves your problem.
How to create a lookup site column in Excel?
Then in the additional Column Settings, give a description of the column and then in the Get information from: choose the list name from which you want to bring the data. Then “IN this column”, choose the column which you want to show, here I have chosen Title column. Then click on OK which will create all the lookup site column.
Can a lookup column point to a different SharePoint list?
A lookup column gets the values in its drop-down from a different SharePoint list. You can have people’s names in text fields in a different SharePoint list and use these names in a lookup column. But the result will be text fields, too. You cannot create a lookup column that points to a person/group column in a different list.
Is it possible to list people O group column in SharePoint?
Is it possible to achieve this using OOTB or should I go for custom coding (If so how). You should be able to do it with the Lookup column and selecting ” Add a column to show each of these additional fields ” but there are some limitations for this approach. You can do it for only ID, Number, SingleLine of Text & Date Time columns.
Why is the person or group column not showing results?
My Datasource is Sharepoint online list. Within this i got a custom Person or Group site column, that is pointing on a Sharepoint Group. When creating a new record in Power Apps, the Drop Down field is showing 0 results …. but creating a record within Sharepoint directly does not show issues.