Dubai Power BI & Power Apps User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
 View Only
Expand all | Collapse all

Solution to recover your data in case there is drop in the connection while you are syncing your data to the server thru On-Prem Gateway

  • 1.  Solution to recover your data in case there is drop in the connection while you are syncing your data to the server thru On-Prem Gateway

    Posted Oct 13, 2019 03:42 AM
    Hi Folks, 

    i found new way to recover your records in case there was drop in the connection for the gateway at your server which sometimes leads to lose you data, 

    hope it will be good for you as ref, 



    DisplayMode.Disabled;

    Collect(offlineCollection11,{
    MyBuilding:DataCardValue18.Text,
    MyFloor:DataCardValue25.SelectedText.Value,
    MyArea:DataCardValue21.SelectedText.Value,
    MyRoom_type:DataCardValue43.SelectedText.Value,
    MyRoom_no:DataCardValue27.SelectedText.Value,
    MyTopic:DataCardValue47.SelectedText.Value,
    MySubTopic:DataCardValue6.SelectedText.Value,
    MySnag_item:DataCardValue49.SelectedText.Value,
    MyDescription:DataCardValue52.Text,
    MyAttachment:Image10.Image,
    Mytime: DateValue4_1.SelectedDate,
    Myuser: DataCardValue42.Text,
    MyAction: DataCardValue23.SelectedText.Value,
    MySubmit: "false"

    });
    Clear(offlineCollection1);
    ForAll(offlineCollection11,
    Collect(offlineCollection1,{
    ID: CountRows(offlineCollection1)+1,
    MyBuilding :MyBuilding,
    MyFloor :MyFloor,
    MyArea : MyArea,
    MyRoom_type : MyRoom_type,
    MyRoom_no : MyRoom_no,
    MyTopic :MyTopic,
    MySubTopic :MySubTopic,
    MySnag_item : MySnag_item,
    MyDescription :MyDescription,
    MyAttachment:MyAttachment,
    Mytime:Mytime,
    Myuser:Myuser,
    MyAction:MyAction,
    MySubmit:MySubmit
    }
    ));

    UpdateContext({pop1: false});
    SaveData(offlineCollection1,"offline_data1");
    UpdateContext({pop1: true});UpdateContext({offline: "Data locally Saved!"});DisplayMode.Edit



    ------------------------------
    Osama AlAhmad
    Sr. Business Intelligence Analyst , MCP
    Consolidated Contractors International Company
    00971503722060
    ------------------------------


  • 2.  RE: Solution to recover your data in case there is drop in the connection while you are syncing your data to the server thru On-Prem Gateway

    Top Contributor
    Posted Oct 15, 2019 08:55 PM
    Glad you share it Osama.

    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------