Gallery shows updated SharePoint list items

(0) Share

Report

Posted on by da1ve

340

Hi guys,

Is it possible to have a feature that could show if a SharePoint list item has been updated? So the scenario is we have a gallery that is showing SharePoint list item entries. If an item was updated, it would either have like a warning icon or put some of the text in bold (or some other way of visually showing the update). Just a mechanism to show there has been an update since the gallery was last viewed.

Is this possible? Also bearing in mind there would be up to 3 people viewing the app\gallery.

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @da1ve,

To capture the updates of SharePoint list items, there is a default field "Modified". Once you update an item, the Modified field will be written by the current date time.

So we could create a variable to compare the current time with the "Modified" field, once "Modified" field is equal to the current time, display a banner message telling that there is updates and make the specific row bold with red font color.

Inset a Timer and set the following property:

Set the OnStart property as below:

If(Text(ThisItem.Modified,"dd/mm/yyy hh:mm:ss") =Text(Now(),"dd/mm/yyy hh:mm:ss"),Notify("Record"&ThisItem.ID&"has been updated!",NotificationType.Success));Refresh(YourList)

Set the TemplateFill property as below:

If(Text(ThisItem.Modified,"dd/mm/yyy hh:mm:ss") =Text(Now(),"dd/mm/yyy hh:mm:ss"),Red)

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

So I can see the timer starting and resetting but nothing in my gallery changes. If I look at the SharePoint list modified column I can see its updated. If I add a text label for Text(Now(),"dd/mm/yyy hh:mm:ss") it shows the correct date and time.

I copied your text and replaced "your list" with the list actual name. Is there anything else I would need to adjust?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @da1ve，

Try to delete the Refresh() function from the formula.

Not sure the details that how you configure the Timer, all the necessary settings for Timer is mentioned in my previous reply, you should set the Duration property with a "just right" number, 6000 is the one works in my scenario.

I have tried a less or more number, neither will do, you could try it on your side.

Too less time difference could not make the banner message pop up because the captured now() time changes so fast that we could not compare it with the modified time.

Further, if you have three users online and once two of them update at the same second, the time dfference may not make the formula work. That's the point of your issue, the seconds difference is difficult.

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

So this method appears to work if I update a record from the PowerApps gallery. I was wondering if this functionality could be introduced if a user other than myself made an update either from the PowerApps gallery or in the SharePoint list itself?

Thanks,
David

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @da1ve,

Absolutely they can, you just need to share the app and the data source with them and make you have assiged the Edit permission to them as well.

We could achieve this in Power Apps Gallery, however we could not do this kind of UI message in SharePoint list.

Was this reply helpful? Yes No