Collections last Synchronization Date and Time

[AVTS]

Experts,

I'm transferring data from flow (Getpmo) to the powerapps collection (test8). I'd want to show the final data downloaded into the collections. Like Last synchronization data and time 

The following code is used in the buttonclick.

If( Connection.Connected,
ClearCollect(test8,Getpmo.Run());
SaveData(test8, "MyLocalData");,
LoadData(test8, "MyLocalData", true )

Sample Expected layout  output . 

How to achieve this.

[iAm_ManCat · Accepted solution]

Hi,

Just have a separate variable and storage for dealing with the last submitted time:

If(
   Connection.Connected
   ,
   ClearCollect(test8,Getpmo.Run());
   ClearCollect(test8_synctime, Now());

   SaveData(test8, "MyLocalData");
   SaveData(test8_synctime, "MyLocalDataLastSyncTime")
   ,
   LoadData(test8, "MyLocalData", true );
   LoadData(test8_synctime, "MyLocalDataLastSyncTime", true )
)

Then use test8_synctime for your 'last synchronisation' label,

Cheers,

Sancho

[AVTS]

Hi thanks you response. i am getting following error while assign in to the table text field ,

[iAm_ManCat]

Hi,

Could you show your formula please? The error is indicating that there is a formula error, and when I tested it on my side it worked correctly,

Many Thanks,

Sancho

[AVTS]

Text(test8_synctime,"DDMMYYYYHHMMSS")

[AVTS]

Clearcollect results looks correct . But when you are trying the display it in any label then its now coming correctly. 

ClearCollect(
test8_synctime,
Now()
);

What is the correct label formula to display the clearcollect date and timing details 

[iAm_ManCat · Accepted solution]

Hi,

Yes, happy to help

As we are storing this in a collection you can't just reference it directly, it is stored within a collection and is the only item in the collection so we need to use the First() function to pull back the stored value:

Text(
     First(test8_synctime).Value,
     "ddmmyyyyhhmss"
)

Please could you try that and let me know if that works for you,

Cheers,

Sancho

[AVTS]

thank you @iAm_ManCat