Power Platform Community Forum Thread Details

Hi All

Please help! I have created an app to write sales information of items and their approval dates to a dataverse table (using patch function not via a form). The reason I have done so, is that I require the historical submissions for the items. In order to do this, I created a column which generates a unique ID then every time I click submit in the form it will create a new row in the dataverse table (with the same unique ID) rather than modifying the existing row.

What I am struggling with is the gallery, if you select an item on the gallery, it prepopulates the input fields so that you can amend them as required, however, I do not want the gallery to show all of the items from the dataverse table, I only want it to show the latest submission for each unique id, except if the archive checkbox was selected for the last submission (then it should not appear at all). I would assume this would require a formula in the item section of the gallery but I have not been able to find any solution in this regard.

Below screenshot shows a very high-level view of the app and you can see what I am struggling with in the gallery as it shows 2 ABC submissions (date shown there is the modified date from the dataverse table). To note that there will be more inputs and will tidy up thereafter

Thanks for your help