Sharepoint Online - No Columns were found

[Anonymous]

Hi everyone,

Really stuck with trying to connect to a 'Custom' SharePoint list within Project Online. I want to pull the Project Status Update lists from each individual project site.   I have used the below to pull the data, which seems to work as expected however when I then go into the data and try to expand the column, it comes back with 'No columns were found'.   Does anyone know what I am doing wrong?

let ProjectStatusUpdate = (site as text) =>
let
Source = OData.Feed(site&"/_api/web/lists/GetByTitle('Project%20Status%20Update')/Items()?$Select=Title,KeyAchievements",
null, [Implementation="2.0"]
)
in
Source
in ProjectStatusUpdate

[v-stephen-msft]

Hi @Anonymous ,

Sorry I can't reproduce your problem. Have you checked that the table in the row does have data? There is also a row showing the error.

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.

[Anonymous]

Hi Stephen,

So, i don't believe it does have data in it. However, i didn't think this would stop you from creating the report as the sampe report packs are all empty at the start? The error is from the timesheet project, so that's fine.

Thanks

[v-stephen-msft]

Hi @Anonymous ,

If there are columns in the table that can be expanded, you can click on the table and you can see the data in the table.

If there is no data in the table, it can't be expanded naturally.

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.