Forum Discussion

Dev1968's avatar
Dev1968
Copper Contributor
Nov 21, 2022

Sharepoint List - Get emailID using phone Number

Hi I have a sharepoint list  having phone number and the monthly charge and email ID fields . These data are being populated from a excel sheet . Excel sheet doesn't have the email ID so the email ID field is blank while uploading the data .. Is there a way that i can populate the email ID using the phone number and update the EmailID field ?

rgds

AD 

SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Nov 21, 2022

    Dev1968 Check if Office 365 Users connector helps you for getting user profile properties from Azure AD. You might be able to pull users using this connector in power automate and match the phone numbers in excel with phone numbers in returned results from this connector

     

    Then you can update the SharePoint list items using "Update item" action.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources