question

K3v1nC avatar image
0 Votes"
K3v1nC asked MayankBargali-MSFT commented

Update SharePoint Item with logic App "Title" Field not exist

Hi

I try to update a Sharepoint Item with logic app but i have following error:

82551-img1.png


82514-img2.png82533-img3.png




Any answers would be appreciated Thanks

office-sharepoint-onlineazure-logic-apps
img1.png (31.8 KiB)
img2.png (18.1 KiB)
img3.png (9.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmosWu-MSFT avatar image
0 Votes"
AmosWu-MSFT answered

Please check whether the Title column of the corresponding item is empty. When I test the Title is empty, this error appears.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MayankBargali-MSFT avatar image
1 Vote"
MayankBargali-MSFT answered MayankBargali-MSFT commented

Hi @K3v1nC

Welcome to Microsoft Q&A! Thanks for posting the question.

As per the error message expression body('Get_item')['Title'] means that the output of Get_item action doesnot have the property 'Title'.
This happens only in the scenario when you have created the item without the Title on your selected list on SharePoint site.

The same can be verified by navigation to the run history of your logic app and verify if the output has a missing Title field for your "Get item" action or navigate to your SharePoint site list item and verify if there is any item with missing Title.

If in your business requirement this can be an empty field then you can add one more action to verify if the Title property exists in the output before executing the "Update Item" action.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MayankBargali-MSFT

Thanks for your effort, but i missed something.

The problem isnt in the Get_item action or missing title field.
Its because the HTTP Request action dont give a correct value back, so the Get_Item action call ".../Items/" and i became
a array instead of an item return.

Sorry for the late reply :)

0 Votes 0 ·

@K3v1nC Thanks for your response and glad to know that you were able to find the root cause of the issue. Feel free to reach out to us in Microsoft Q&A if you need any assistance in the future.

0 Votes 0 ·