SharePoint Lookup

Flinn, Randal J 281 Reputation points
2022-06-10T11:28:27.777+00:00

Hello,

I have a list where employees (Created By) enter records via mobile devices. I would like for a Lookup field (Supervisor) to auto-populate based on the Created By value. My understanding is that mobile devices can't use a lookup to separate list; however, can a record be created on the mobile device and the lookup/auto-populate occur in the "desktop" version (I do not need the lookup value on the mobile device.).

Example

Record/fields entered on mobile device: Created By, Created, Building, Work Performed

Record fields on "desktop" version: Created By, Created, Supervisor (based on Created By value), Building Work Performed

Thanks

Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
0 comments No comments
{count} votes

Accepted answer
  1. Xuyan Ding - MSFT 7,601 Reputation points
    2022-06-13T10:04:28.203+00:00

    Hi @Flinn, Randal J ,

    Per my test, the lookup column cannot directly refer to the Created By field in the list. As a workaround, we can use Flow to update the supervisor column. But since the relations between the created by and the supervisor column is unclear, an example will be provided to update the supervisor column with the display name of Created by column. After an item is created, the Supervisor column will be automatically updated to the person who created the item. As it is more related to Flow, if you have other requirements about this task, please reach to Power Automate forum for help.

    Specific steps are as follows:
    1.Create a Person column Supervisor
    2.Create a flow->See your flows->Create: Automated cloud flow->When an item is created->Fill in Site Adress and List Name->New step->Choose Update item->Fill in the appropriate information and select Created By DisplayName in the Supervisor column->Save
    210814-image.png
    210709-image.png
    210756-image.png
    210710-image.png
    210824-image.png
    210831-image.png
    210739-image.png

    3.Create an item and the Supervisor column will be added automatically.
    210740-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.