Forum Discussion
Georgie_stanley
1 year agoNew Member
E0f error
Hi, how do I fix this error? let Source = Json.Document(Web.Contents("https://dominowb.sharepoint.com/sites/WestonBeamor/Shared%20Documents/Plannerdata.json")), #"Converted to Table" = Table.F...
Anonymous
1 year agoNot applicable
Hi shreebidwai
It has the error in the following part.
in
#"Changed Type",
Output =
Table.View(
null,
[
GetType = () =>
type table [taskname = Text.Type],
GetRows = () =>
GetData(),
OnTake = (count as number) =>
if count=0
then
#table(type table [taskname = Text.Type], ()
else
GetData()
]
)/*,
BufferedOutput = Table.Buffer(Output)*/
in
//GetData()
Output
//BufferedOutput
In the 'in' part, you can only return to the steps in the let part. If you add other content after the 'changed type' in the 'in', it is not possible. You can treat this part as a step, just in the 'let' and finally return this step in the 'in'
e.g
let
output=....
in
output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.