Concatinating fields in graph call

anthony 21 Reputation points
2022-10-28T03:20:15.727+00:00

Hi All,

Is it possible to concatenate a string to a select field using Microsoft Graph. Take the example below.
Ultimately, I would like a custom field returned from the graph which contains data from another field

   Example:  
   https://graph.microsoft.com/beta/groups/{groupId}}/sites/root/lists/teamforms/items?expand=fields(select=field1,filed2,concat(field1, ' - some string')&$filter=fields/field1 eq 'saved'  
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,447 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,810 questions
0 comments No comments
{count} votes

Accepted answer
  1. Srinivasa Rao Darna 6,711 Reputation points Microsoft Vendor
    2022-10-31T13:06:53.793+00:00

    Hi @anthony ,

    Thanks for reaching out Microsoft Q&A!

    concat is not valid function or query parameter in Microsoft Graph for SharePoint.

    Consider making use of SharePoint Calculated Fields, for this test I created a calculated field as below.

    255665-image.png

    • In SharePoint List view I can see as shown here.

    255676-image.png

    • Microsoft Graph API with above Calculated Field.

    255579-image.png

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


0 additional answers

Sort by: Most helpful