To display records based on Status

(1) Share

Report

Posted on by Sidhant_02

986

Hi everyone,
I wanted to implement the following:

So in the LHS side I was thinking of having a drop down which has all the names of the users or use vertical gallery to display all the names (not fixed), but on selection from the drop-down or the vertical gallery all the details of the course for the choosen user should be displayed
(In my application the courses are categorized based on Difficulty which is a choice column with values like Beginner, Intermediate, Advance, Expert)
Example: Sam is a user and he updates the status for 2 courses in Beginner and Intermediate category then when the admin navigates to the above screen and selects Sam then he should the latest changes .
So to achieve this I have created a new SP List to keep a track of the changes which is :

But don't know how to proceed with this

This is in continuation to one of my older query for the first half of my query I got the answer i.e. update a choice column in SP list using a single button, so for more information you can refer this: Reference (this is marked as Completed as I got the answer for first part but not the second part which I have mentioned)

Please do let me know if you know how to achieve the mentioned functionality.

Regards,
Sidhant.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sidhant_02 ,

What is the part you need help with? Is it how to track changes or is it to display the changes? Or both?

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer ,
I will need help for both.

Regards,
Sidhant.

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Sidhant_02 ,

To record changes, you'll have to set up a mechanism that save the changes in a separate list whenever users make the change.

Let's say you have a form (Form1) with 3 values (DataCardValue1 (ID), DataCardValue2 (Title), and DataCardValue3()Difficulty)).

Before submitting, save the old values in a variable:

UpdateContext({locOldValues: LookUp(DataSourceName, ID = Value(DataCardValue1.Text)}); SubmitForm(Form1);

In the OnSuccess property of the form, compare the old values against the new ones and create an item in the Changes list:

Clear(colChanges); If(locOldValues.Title <> Self.LastSubmit.Title, Collect(colChanges, {NewValue: Self.LastSubmit.Title})); If(locOldValues.Difficulty <> Self.LastSubmit.Difficulty , Collect(colChanges, {NewValue: Self.LastSubmit.Difficulty})); Patch( Changes, Defaults(Changes), { UserEmail: User().Mail, DateTimeStamp: Now(), UpdatedItemID: Self.LastSubmit.ID Changes: Concat(colChanges, NewValue, "; ") } );

Please play around with this and once it works we can move on to the second part.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer ,
Thanks for the reply.
So in my case I only have one column that will be updated that is the Status column (Choice column) which is only going to be updated rest of the fields will not be changed

So for testing purpose earlier I had created another SharePoint list named 'TrialList' and had the following columns:

In this Stage is a choice column (similar to Status in the original SP List: Courses) so what I have done created a separate screen:
Created a button which looks like Text and on-select the stage value gets updated

On-Select of the Stage button:

But currently it is giving type mismatch error

Also you have suggested I have created a new SharePoint list that will keep the updated records or modifications that are made which is named as usersCourseList which is:
(In this Title will be the name of the course courseLevel is the Difficulty level and courseStatus)

So what should be done here, and if you need more information let me know.

Regards,
Sidhant.

Was this reply helpful? Yes No
BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Sidhant_02 ,

The issue is exactly as described by the error: a record can't be compared with a text.

To fix that, you can extract the text from the record by selecting the Value column:

... Stage.Value = Label50_2.Text ...

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Understood so now I have completed the part -1 that is saving the choice column value in a variable but in my case I am not using any form rather just a gallery in which all the details are been shown
so now to save these details in the new sharepoint what should be the next steps should I just directly compare the values old and new one and use the Patch function as you have mentioned in your reply but that is w.r.t forms what about data in gallery. As in my case I have to keep track of the Status (for every user in isolation)

Regards,
Sidhant.

Was this reply helpful? Yes No