Forum Discussion
expanding record column
Hi
We have a Sharepoint Helpdesk and I need to create a Report to Show the SLA's for our Business Units.
The Business Unit is displayd as Record and i would like to expand the record to get the Title column and Customer Group Column.
When i Click on the button to Expand the Column, it just keeps Loading. (See Image attached)
I have tried Using advanced Editor to expand the Column but dont have any success. The code i am using is #"BusinessUnit" = Table.ExpandRecordColumn(#"BusinessUnit", {"Title", "CustomerGroup"}, {"BusinessUnit.Title", "BusinessUnit.CustomerGroup"})
Can anyone please assist as i need to have these to Columns (Title and CustomerGroup) in the same table as all the other columns
4 Replies
Can you click the highlighted "record" in that column to see what's inside? By the way, what is the data source in your case?
Hi, i am using sharepoint online as the data source. the columns inside the record that i want is Highlighted in yellow
clintonbreed wrote:
Hi, i am using sharepoint online as the data source. the columns inside the record that i want is Highlighted in yellow
I'm not familar with Sharepoint, what exact is that in sharepoint, a list or whatever? I'd like to try reproduce your issue if I could get more details.
By the way, could you try to filter your orginal dataset to have only one rows and then try to expand. I doubt it is some performance issue.
