Add a New Managed Property

[OroskiBR01]

I have a list in Sharepoint and I'm creating a query in that list together with Graph API and Power Apps, but I can't find some columns in the Sharepoint list to specify this in the API.

For example, I have a column named "DWGRev" that was created more than 3 months ago and is not included in the "Managed Properties" list. I understand that I need to add it manually, correct?

I added manually but some configuration is not correct, I tried to insert the column in the list of Properties this way:

Sharepoint should not add all columns automatically in properties ?

I manually updated the Index of the list and even so this "DWGRev" column and some others did not appear in Managed Properties

[#2]

@OroskiBR01 Yes, you are right. SharePoint does not create the managed properties automatically for list columns. SharePoint creates the managed properties automatically for site columns.

You have to create the managed properties manually for list columns and then map the crawled properties with managed properties. Edit the managed properties settings and make it Retrievable, Searchable, Queryable, Refinable, Sortable, etc. to use in Graph API calls or SharePoint search.

Manually re-index the SharePoint list from list settings --> advanced settings. Wait for 1hr (preferable more than 15 minutes) and then try to use it in your API calls.

---

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.

[#3]

Just one more example please,
For new columns I managed to understand the correct model to do but I'm trying to track existing columns from my Sharepoint list and this is difficult to achieve.
Step1:
Create a Managed Properties:
-Property name: any name (column name)
-Type: Text or some another kind ( when the column in sharepoint is a lookup, need I select the Text type?)
-The select a Searchable, Queryable, Refinable, Sortable etc... normally Retrievable Its enable to edit this field.

Step2
Search the column name in Crawled Properties:

- If Its already exist, need I to Mapping this crawled properties with Managed properties column name?
-Is its doesn't exist, need I to create a crawled properties and then to add a mapping with managed properties column name ?


Step3
Manually reindex and wait 1 hour and try do use in Graph API.


This is a little strange for me because at no point am I indicating which column I am adding a crawled property from, only in the Graph API do I indicate the column name and who doesn't always match exactly the same name in Sharepoint.
It's the first time I'm doing this so I couldn't understand the reason for some columns sharepoint automatically create all this traceability and not create for other columns.

Thanks in a advance,

[#4]

@OroskiBR01 You cannot create crawled properties manually in SharePoint.

Crawled properties will be automatically created by the SharePoint when you create the columns and add data to those columns (after the search crawl runs - usually within a hour after adding the data). Crawled properties may not be created if you have created the columns but not added any data in it.

Usually crawled property names are similar to the column names in the list (some characters related to data type maybe available in the names). After creating the managed properties, you HAVE TO map those with the related crawled properties manually.

If you want to use the columns in the SharePoint Search API or Graph API calls, you have to use the managed property names (not column names in the list or crawled property names). Hope it helps!

---

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.