Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

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". ...
Need Help
Show and Tell
Tips and Tricks
  • HughLa's avatar
    HughLa
    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
    Custom1

     

    Let me know if it does.

     

    Regards

    Hugh

HughLa's avatar
HughLa
Icon for Resolver IV rankResolver IV
3 years ago

Yes, it should be possible to do it with a Sharepoint list. 

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago

Hi Hugh

Thank you I will try it.

Regards

Heinrich

  • HughLa's avatar
    HughLa
    Icon for Resolver IV rankResolver IV
    3 years ago

    Let me know if it works! Im curious!

     

    Regards

    Hugh

    • Heinrich's avatar
      Heinrich
      Icon for Post Partisan rankPost Partisan
      3 years ago

      Hi Hugh

      I tried it but the Table is not showing up, as the table is a reference to another one.

      Is it possible to display reference tables on Power Query?

      Regards

      Heinrich

      • HughLa's avatar
        HughLa
        Icon for Resolver IV rankResolver IV
        3 years ago

        Hi Heinrich

         

        Would you be able to share your M code for that query? Just remove any sensitive information.

         

        Hugh