To change the status of an item on-click and show show items based on status of user to admin

(0) Share

Report

Posted on by Sidhant_02

986

Hi everyone,

I have a course screen where I am displaying list of courses (from a SharePoint list named: Course List) which is like this:

I have used a Horizontal Blank Gallery in which I have used a Image (common to all courses), three text labels (for title, description and Difficulty)

So currently on the Course Information screen I am displaying Title, Description, and Difficulty (this is a Choice field) the SharePoint structure look like this:

So now I want to add a button (which looks like Text) which is used to denote the status for the particular course which has values like Not Started, In-Progress and Complete.
Example: Assume a Tim has logged in to the application -> He navigates to the Course Information screen -> Chooses the course category (here: Beginner) in the course list and there we have an attribute which is changes its value (like a choice column) on-selecting it (don't want to use drop down to change the value) the value should be changed on-click and saved to the sharepoint. By default the value will be Not started. I wanted something like the below picture: (Wire frame)

Something just like this:

So when user clicks on the status:
Initially it is set to Not Started (once they click it is changed to)-> In-Progress -> Completed this should be the sequence when user clicks and this should be saved in SharePoint list (for which I was thinking of creating a Choice column named: Status with values 'Not Started', In-Progress, Completed)
So what modifications should I do to get this functionality?.

The other requirement was when a user with Admin role logs in there will some change in the Course List page. Instead of having a drop-down which shows Difficulty (Choice column) values like Beginner, Intermediate, Advanced. I want to show all the list of users and on selecting a particular user the Administrator should be able to see all the Course information for that user.

Example: Assume Tim has 2 courses which he has started one from Beginner and one from Advanced (difficulty), so if admin selects Tim from the users drop-down then they (user with Role: Administrator) should see all the courses along with the status for that particular user, in this example it should the status of one course from Beginner: difficulty as Status: In-progress and one course from Advanced Status: In-Progress and rest of the course status should be Not Started

The wireframe:

So I have a created a button (which looks like text) and added a label beside it which displays the Choice column value (have added Status which is a choice column with default value as Not-Started) but not sure how to update the value on the go when the button is clicked

On clicking Button16 the status column should be updated and saved in SP list and displayed in the label.

Note: I also tried removing the Choice column (Status) and added it again (Refreshed the SharePoint List) but still not able to get the Choice column in the expression

Regards,
Sidhant.

Categories:

Building Power Apps

I have the same question (0)

All responses (41)

Answers (2)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
To create the experience of clicking the label and having it start the course (and update accordingly), you will need to add some conditional logic to the OnSelect property of the label and perhaps the Color property too.

I suggest putting a Switch() statement in the OnSelect property of the label that uses its current value to decide what next value to Patch() to the underlying datasource:

Switch( ThisItem.Status.Value, "Not Started", Patch(....), "In-Progress", Patch(....), "Completed", Patch(....) )

I'll warn you know about an issue I've experience with using Patch() directly on the same datasource as the gallery it is within: sometimes the gallery doesn't read the datasource correctly right after the update, so what is displayed on the gallery doesn't show the results from the Patch(). To get around this, it can be helpful to use a collection based off the datasource rather than the datasource itself in the Items property of the gallery, giving you more control over when you want the gallery to update.

Hope that helps,

Bryan

Was this reply helpful? Yes No
Pstork1 69,554 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Use an if() with patch statements to patch the column in SharePoint when the button is pressed. Something like this.

if(status.value="Not Started",patch(status: {value:"In-Progress"})if(status.value="In-Progress",patch(status: {value:"Completed"})))

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bryan ,
So you are saying to use a collection instead of the datasource directly, so in my scenario I just want to update only 1 attribute which is Status (as the user is not allowed to edit any other details, only the user with Administrator user role can do it). So in that case if I have to create a collection should I create it for one attribute or all of them, if so how to create the collection and update it and display the result?.

I have created a collection named courseTemp, which is created on select of the button on Home screen which navigates to the Course List_2 page like:

Then on the Course List_2 Page (Items property)

So now after creating a collection how should the value of one attribute (here Status be updated on select of a button/label in the sequence which I have mentioned earlier) be updated and saved to SP list (so that for other user roles: Admin, where I want to show the datasource directly (as they will only be reading the data))

Also the other thing, that collection only supports 500 records beyond that it can give some delegation warning so in that case will collection be a good choice?
If possible could you just explain it in few steps.

(What is wrong here?)

Regards,
Sidhant.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 ,
Was getting Status (attribute is not recognized)

This is my SharePoint List with the new column (Status: choice column)

Initially all records have Status as Blank so it should be "Not Started" on clicking the Status button/label

As @BCLS776 (Bryan) has mentioned in his reply that using Patch on the same data source can create some issues (gallery does not read the datasource correctly after the update), so for that he suggested to create a collection, but collection also has few limitations (which I have mentioned in the reply) so in that case is this approach a good option or is there any other option which display the results in immediately after the update is been done?
Also if the value is blank initially then will the condition be:
If (Status.Value = "", Patch(Status:{Value: "Not Started"}))

Regards,
Sidhant

Was this reply helpful? Yes No
Pstork1 69,554 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Check the URL of the Status column in the Column settings and look at the end of the address. That will tell you what the internal name of the Status column is. Status.value should be recognizable if Status is the internal name of the column.

There is nothing wrong with using Patch on the data source while using a gallery. You just need to add a refresh(<<name of data source>>) after you do the patch to make sure it picks up the changes. That's definitely better than using a local collection.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1 and @BCLS776 ,
First, I did try to check the URL simply by selecting the Edit Column option but did not get anything specific
It was common for all other columns as well. So then I choose Settings -> List Settings -> Choose the Choice column (Status) and then got this:
In this the Field name was set to Status so I tried using the If statement (which you gave earlier but it still said Status is not recognized)
Also, could you let me know where the refresh should be added in the expression.
And the particular logged in user should see their respective changes (for other users the changes made by one user should be not visible or shown. Like User 1 makes a change for Beginner course from Status: "" (blank to In-Progress then User 2 should not see the same change for Beginner Course instead it show the default values or the changes saved by User-2 ; And this should be done based on the Login credentials and not using MS Office 365 connector. Here I am using a SharePoint list named "App users" which stores the username and password. So based on that the changes made to the course list should be shown to user, which will be different for every user)

If @HenWang (as you have helped me before with this), could you please have a look at this as well.

Regards,
Sidhant.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCLS776 ,
As @Pstork1 suggested I did check the URL for the Status choice column in the SharePoint and it was the same that I was using but still it is giving me the error that the choice column name is not recognized
So could you please let me know how to resolve this?

Regards,
Sidhant.

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Also the other thing was the Status should be changed based for particular logged in user only.
So for example:
If my app has 3 users: Sam (Role: employee), Tim (Role: employee) and Jim (Role: Administrator)
If Sam makes a status change for one of the course (Beginner course : Staus is changed to Completed) then those changes should be only for Sam and not for other users (like Tim) i.e. for other users there should not be any change (like for Tim he should see the status as default value or if he has made any change to it then that should be visible).
So I was trying to do this:
But this might change the Status attribute for all users (like if Sam makes a change then other users will see the same status, which should not happen)
So in this case how to maintain isolation between users and the status attribute @Pstork1 and @BCLS776

Regards,
Sidhant

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

I am only able to see one option for Status which is:
So I have checked the URL in my sharepoint list which has the same name (mentioned in my reply)
So how to set the value for a particular user which means:
(Sorry if I am repeating it again):
There are 3 users in the application :
User - 1: Updates the status for 1 course in Beginner to Completed then only this user should see the status as 'Completed' and not other users
User -2 : When he/she logins in and check the Course screen the status for the Beginner Course should be the default value (or blank in my case as its not set)
This categorization should be done based on the logged in user details (based on the user logged in)
@Pstork1 , @BCLS776 (Bryan) do check and let me know.

Regards,
Sidhant

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCLS776 ,
I did try to use the switch statement but was not sure on the Patch function so I came up with this
Currently my start value will be blank so could you share the Patch function what should be the syntax for it and the sequence of status will be ""(Blank)-> 1st click: Not Started -> (2nd click) In-Progress -> (3rd click) Completed
Please let me know.

Was this reply helpful? Yes No