SharePoint List connector - get to the comments/all activity data

[moomarine]

Hi

Im trying to get to the data for the comments/all activity fields within SharePoint list Online. See below screenshot example:

Ive connected to the list data but cant find the comments/activity data anywhere, i think i have looked in all the Records/tables as below screenshot but may have missed it. Please can someone help.

[jcountryman]

@v-stephen-msft OP says they can't find the comments in the table, so they've clearly _already_ inspected the lower-level data. If it can't be done, say clearly "it can't be done," because _that's_ helpful. 😤

[damancini24]

Hi were you able to do this? I am not finding a way to do it.

[v-stephen-msft]

Hi @moomarine ,

You can try to expand the records or tables. Please kindly refer to

Extract records from a list to table

Records in Power Query – how, when and why

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.