Forum Discussion
Heinrich
3 years agoPost Partisan
Show Text when No Data in a Table
Hello I have a Table-Visual which has "Tracking-Numbers". Sometimes there are no data then the table is empty. Is it possible to change the empty table with a table which has a remark "No Data". ...
- 3 years ago
Hi Juan
I am glad that it is finally working!
This code should work for you:
let Quelle = SharePoint.Tables("https://axa365.sharepoint.com/sites/AXA-MicrosoftTeamsService", [Implementation="2.0", ViewMode="All"]), #"5aaa8718-9d99-4675-9214-078e6e3131a7" = Quelle{[Id="5aaa8718-9d99-4675-9214-078e6e3131a7"]}[Items], #"Hinzugefügte benutzerdefinierte Spalte" = Table.AddColumn(#"5aaa8718-9d99-4675-9214-078e6e3131a7", "Custom_Summary_as_Text", each Html.Table([Summary],{{"PlainText",":root"}})), #"Erweiterte Custom_Summary_as_Text" = Table.ExpandTableColumn(#"Hinzugefügte benutzerdefinierte Spalte", "Custom_Summary_as_Text", {"PlainText"}, {"Custom_Summary_as_Text.PlainText"}), Custom1 = if Table.IsEmpty(#"Erweiterte Custom_Summary_as_Text") then Table.InsertRows(#"Erweiterte Custom_Summary_as_Text",0,{ [#"Tracking-Number" = "Table Is Empty",#"Escalated" = "False"]}) else #"Erweiterte Custom_Summary_as_Text" in Custom1Let me know if it does.
Regards
Hugh
Heinrich
3 years agoPost Partisan
Hi Hugh
I wanted to do it today but I don't have the rights (company security related).
Need to do it this evening.
Take care
Heinri