web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need help in Updating ...
Power Automate
Unanswered

Need help in Updating Lookup field property for SharePoint list to be changed using REST API

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Team

 

Need help in Updating Lookup field property for SharePoint list to be changed using REST API. My flow is running successfully but it isn't changing the "Show Field" property. Below are the details. The property currently set is Sr.No. 16 which I would like to change it to 20, reason I am want this flow is to change this property for around 200 sites at once. 

 

Sr. No.Show Field drop down optionsExact value need to pass Lookup Field property
16Name (with presence)ImnName
20Name (with picture and details)NameWithPictureAndDetails

 

 
 
Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at

    Hi!

    Can you share a screenshot from your current flow design? The more info context you can provide, the faster you will probably get a useful answer

    Thanx!

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    May I ask you why you using REST API? Power automate update item support direct update without using REST API.

     

    This blog post may be useful

     

    https://prairiedeveloper.com/2018/01/using-microsoft-flow-to-update-a-field-from-a-lookup-column/

     

    Thanks

  • sudharsan1985 Profile Picture
    1,325 on at

    Hi @Anonymous 

    Please follow the below steps to change the 'Lookup Field' property.

    1. You have to use 'Send an HTTP request to SharePoint'

    2. Select the site and list

    3. Select 'Post' for the method

    4. For the 'Uri' try to use the below with your list name

    /_api/web/lists/getbytitle('Your listname')/items

    5. For the headers try to use the below

    Key | Value
    accept | application/json;odata=verbose
    content-type | application/json;odata=verbose

    6. For the body use the below

    { 
    '__metadata': { 'type': 'SP.Data.<List internal name>ListItem' },
    'SampleColId': 'Id of the parent list item',
    'SampleCol1Id':{'results':[Id's of the parent list item]}
    }

    In the above example, 'SampleCol' is the lookup column name and it should be given like that and the values to be passed is the item id of the lookup list item. The same for the multi lookup column but the value has to be passed is the array of Ids.

     

    Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
    -Sudharsan K...

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     I paste the screenshots hereFlow Logic.pngFlow Result.png

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    The body returns the same existing field name every time I run the flow. could you please help. The reason for using REST API is to perform the loop to atleast 100+ sites

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This is really helpful, but I want to change "Person or Group" Lookup Field type from just Name to Name (Picture and details). That field is named as "Show Field" property for a SP list.

  • sudharsan1985 Profile Picture
    1,325 on at

    Hi,

    You can just use the same method to update the field by using the id of the user. Just the display is based on your selection. Use the ID of the user, the field will automatically updated.

     

    Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
    -Sudharsan K...

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you Sudarshan. You mean to say Guid? I have tried that method and few others for over a week now. if you don't mind could you please specify the id or edit the body below with sample id so I can try that method. Most of the changes I have done usually runs the flow but the property doesn't change.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @abm , I am just looping here to seek your help to below issue as you have helped many in finding solutions. Kindly review the thread and let me know if you can help here please.

  • sudharsan1985 Profile Picture
    1,325 on at

    Hi @Anonymous 

    You should not use the GUID, you should normal ID which is an integer.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 711

#2
Vish WR Profile Picture

Vish WR 691

#3
Haque Profile Picture

Haque 525

Last 30 days Overall leaderboard