cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jof
New Member

SharePoint Online List 2.0 (beta)

In Power BI using the SharePoint Online List 2.0 (beta) connector, how can I extract just the last change from a "Notes" field that is set with "Append changes to existing text"?  The field contains a url like "<a href=""https://...sharepoint.com/sites/.../_layouts/15/listform.aspx?ListId=%7B6DEE6792%2D3287%2D4F8A%2D984C%2DA256D50A6E4D%7D&PageType=4&ID=3"">View Entries</a>".

 

The issue we have is that using the SharePoint Online List 1.0 connector or the ODATA connector the field in the data table is sometimes null.  If we update the "Notes" field in SharePoint then the last changed text in the "Notes" field is retrieved into PBI on the next refresh.  If we update a different field in SharePoint then the "Notes" field will be null in PBI on the next refresh.  I see the same behavior if we export directly from SharePoint into Excel.  The field in Excel will be null sometimes.

 

Thanks

3 REPLIES 3
jof
New Member

Thank you for your reply.  I've never used try and otherwise in M but will check into it.  I don't see how it would work though as we don't get any errors.  There is data in the SP field but the 1.0 connector just doesn't retrieve the data without any errors.

jof
New Member

We currently use the 1.0 connector.  After a user makes a change in SH to a field other than the Notes field, our work around for this issue is that the user must always go back in SP, edit the Notes field, copy the last change, enter it and save it.  This works but is an extra step that wastes time and sometimes they forget to do it.

I thought that as the 2.0 connector always has the url in it, we may be able to use it so the work around would not be needed.  But I haven't been able to extract the text using the url.

lbendlin
Super User
Super User

Yes, I would go for the ODATA or Sharepoint API route.  You can catch the empties in your Power Query via try ... otherwise ...

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!