A type named 'SP.Data.TestListListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.

 Scenario:

Trying to update a SharePoint list item using Send an HTTP request to Sharepoint action in Power Automate.

This is an exception case, and i am writing it only to save someone's else time.

Normally we can use Power Automate to GET, POST, PATCH & DELETE sharepoint list items.
There are standard syntax, you need to follow to do it.

The above title is an exception when your list name has a space when you create it. But when you delete that space later your Send HTTP request to SharePoint starts giving an error. 

To be more clear i had a list called Master_Timesheet. And all i was doing was calling a flow from a Power App button and passing the listitem ID as parameter to the flow

Something like this.

FlowName.Run(ThisItem.ID)

But to my surprise i was getting the below error.

A type named 'SP.Data.Master_TimesheetListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.

Initially i thought that i must have messed up with the Uri


So i hardcoded the ID, but no luck.

I checked my listname and the url says

https://YourServerName/Lists/Master_TimeSheet/All%20Items.aspx

So i tried getting the xml for the item by using the below link

https://YourServerName/_api/web/lists/getbytitle('Master_TimeSheet')/items(6)

and it returned me the xml.

This was really confusing as the flow was still showing me error. 

Then on further investigation i found something very surprising.

https://YourServerName/_api/lists/getbytitle('Master_TimeSheet')?$select=ListItemEntityTypeFullName

This i read in a blog  if the list/ library name has changed after creation. 

The XML i got returned was

<?xml version="1.0" encoding="utf-8"?><entry xml:base="https://YourServerName/_api/" xmlns="http://www.w3.org/2005/Atom" 

xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" 

xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml" m:etag="&quot;141&quot;">

<id>https://YourServerName/_api/Web/Lists(guid'ea980193-53b6-4357-94b8-00098636ceef')</id>

<category term="SP.List" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />

<link rel="edit" href="Web/Lists(guid'ea980193-53b6-4357-94b8-00098636ceef')" /><title />

<updated>2021-05-03T02:31:58Z</updated><author><name /></author>

<content type="application/xml"><m:properties><d:ListItemEntityTypeFullName>SP.Data.Master_x005f_TimeSheetListItem</d:ListItemEntityTypeFullName>

</m:properties></content></entry>


In the above xml what i found strange was SP.Data.YourListNameListItem was different to what i have been using in my flows.

i was using SP.Data.Master_TimeSheetListItem  instead of SP.Data.Master_x005f_TimeSheetListItem

As soon i made the above change in the body of my Send an HTTP request to SharePoint action the flow succeeded. 

Also, a bonus is SP.Data is YourLibraryItem for library and

SP.Data.YourListListITem if its a custom list.

Comments

Post a Comment

Popular posts from this blog

Creating Nested Galleries in Power Apps. (Parent-Child Relationship)

Image
 This is another most common scenario where in client has two parent child lists or any two lists having a common SharePoint column. And clients wishes to have a relationship on the PowerApps screen where in when he/she selects a particular lets say Program in our example. All the respective Projects following that Projects are shown. In such a scenario we can leverage nested galleries. So what we do in here is we add two galleries on our Power App screen. For Programs gallery the Left one on the screenshot above, we connect it to the Programs list For Second gallery we will connect it to the Projects list. But this is where the magic happens. Here we use Filter () function. So what we do in here is we set the Program's column value in Project's list equal to the Selected Program of left Gallery. i.e. the gallery connected to my Program's list. A more complex version of the same is where you inset the nested gallery inside your parent gallery. In this too everything remains
Read more

How to reset a datepicker control in PowerApps?

Image
 Scenario: Simple reset a date picker control. Issue, you can't use normal Reset() function to reset the datepicker control. Solution: Simple create a variable Set(varResetCD, True) and use this variable to update the reset property of DatePicker control. The below Reset() won't work in case of datepicker control We need to create a variable and use it at the Reset property of the datepicker control. Also, if you still see some text inside your date field there are two other places you need to check in one is the datepicker control advanced properties. In the above screenshot all you need to do is clear InputTextPlaceholder. And then select the control and check the DefaultDate property of the date.  This should be set to Today(), you can also change it to something like below If(varResetCD,Blank(),Today()) What this does is sets the control to blank if the variable you have declared above is true. 
Read more

Reset () function failing to work on Edit form for Combo boxes in Power App.

Image
 Hi Good day, Today we have a very interesting scenario. We have a cascading dropdowns on our Power App screen. The flow for these dropdowns is that a user selects the Division, and a list of Business units containing the selected Division is popped down in your Business Unit dropdown. Now to make it user friendly, we have on change code written on each dropdown. So that if the user decides to change the Division dropdown, the Business Unit dropdown is reset. Please remember in here we are talking in regarding to New Form. On Resetting the above Division combo box, since we have written the Reset function code on Change property of the Division Combo box.   Reset(ddBU);Reset(ddBPI);Reset(ddTeams). The above becomes Up till here everything is hunky dory. This is the classic case of how the Reset() function should behave. But that's not, when you move from new form to Edit form.   The Reset function behaves weirdly. It is able to reset the cascading dropdown values like above. But i
Read more