Power Platform Community Forum Thread Details

Hi everyone, I am looking for some consultation.

So I have a stock table like below on dataverse. The data will be update regularly like quantity or stock date.

ID	Item	Quantity	Latest Stock Date
1	Item A	10	2023/05/30
2	Item B	5	2023/06/30
3	Item C	20	2023/06/28

Our managers want to have a date filter and after selecting date, they can see the data from that date.

We are planning to have a separate table to record the history of the items to get the old data from, but we are considering how will we save the history (by every time someone made changes, by hours, by days or by months, etc.)

So, I would like to hear some suggestions from this forum. Maybe some idea about the architectures or is Dataverse/SharePoint a good option for this, etc.

Categories:

Building Power Apps