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
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors