Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Update lookup table values through Rest api in Project Online

(0) ShareShare
ReportReport
Posted on by

I am trying to Project Online Lookup Table value using Send a HTTP request to Sharepoint using Flow. 
I am trying to create new entry in lookup table using Rest but getting an error.


ERROR : An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.
clientRequestId: af31b745-2214-4635-9a45-0fa1311e7d2c
serviceRequestId: aea3c29f-30ba-b000-fc46-67eccb973d3b


Using Post message : 

URI:

_api/ProjectServer/LookupTables('00008e67-65a3-4898-baaa-d82d995bbb02')/Entries/Add

 

Body 

{'parameters':{

'Value':'110',
'Description':'Added from Flow',
'SortIndex':'7',
'ParentId':'dd67bf95-85a3-eb11-bfa0-00155dc0a600'
}}
Using following References https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj668218(v=office.15)

https://docs.microsoft.com/en-us/previous-versions/office/project-javascript-api/jj668483(v=office.15) 
 @Anonymous 

  • dradomtsev Profile Picture
    5 on at
    Re: Update lookup table values through Rest api in Project Online

    Hi @rajatk09 ,

    as said in article Project-docs-pr/LookupEntryCreationInformation.md at master · OfficeDev/Project-docs-pr (github.com) parameter 'Value' is of type LookupEntryValue so the value of parameter 'Value' should be

    {'Decimal':'110'}
    The full body of the request would be like

    {'parameters':{

    'Value':{'Decimal':'110'},
    'Description':'Added from Flow',
    'SortIndex':'7',
    'ParentId':'dd67bf95-85a3-eb11-bfa0-00155dc0a600'
    }}

  • Muthu_Haris Profile Picture
    2 on at
    Re: Update lookup table values through Rest api in Project Online

    Hi Raja, I am also facing the same issue. Did you able to fix the issue

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow