Creating a List of Courses and Displaying it

[Sidhant_02]

Hi everyone,
I wanted to create a page where a Admin create a list of courses like for Power Apps Beginners: Starting with Power App platform, Components; Intermediate Power Apps: DeepLinking Pages, Filter Methods and so on.

Intermediate Courses:

So as you can see above (in the 2 images), for Beginner category there are some courses and when user selects Intermediate the courses in Intermediate: Category should be displayed. Also Admin (UserRole) should be able to add new courses and they should come in respective tabs or under respective category. The Add button should not be shown to other users (except Admin)
In my Users SharePoint List (where all users credentials are stored) like:

(Header)

I have created a new screen named Screen List:

So in the above screen how to create a Tab (like Beginner, Intermediate, Advanced) and show courses based on category in tab container structure or any other format.

And connected (Blank Horizontal List)  to the new SharePoint List named Course List:

So only the administrator should be able to see the Add icon and create new courses. How should the new courses page be created (using a new sharepoint list with following columns Title, Category, Description, Duration) and how will the data saved shown in the respective category
So how should I approach it, please let me know about it.

Regards,
Sidhant.

[WiZey · Accepted solution]

Hello @Sidhant_02 ,

First, for the tabs I recommend using the latest fluent controls they introduced in Power Apps. See https://powerapps.microsoft.com/en-us/blog/modern-controls-coming-to-canvas-apps/.

Then, to create new records in a SharePoint list and display them in a gallery, here is how you can do it:

Clicking on the "Add" button can redirect the admin to a screen dedicated to create a new record. To create a new record, you can either build by yourself a form and use "Collect()" or "Patch()", or you can insert a form control, set it to "New" then use "SubmitForm()". 

To display data from a list based on a criteria, you can use "Filter()". Supposing your courses' level is a choice-type column, you can filter them like this:

Filter(
  SharePointList,
  column = {Value: "Beginner"}
)

The tab control offers a "Selected" property which return the name of the selected tab, you can use it to filter the list based on the desired level of difficulty.

Don't hesitate to ask if you have more questions.

[Sidhant_02]

Thanks @WiZey ,
For the suggestion and steps, I had a few queries though which were:
I have created a button to add new records using EditForm and Submitting it using SubmitForm

AddCourse (Screen):

I also tried the TabList control (Modern control) which you suggested but now I wanted to display records based on the Category type so on click of a particular tab how will the records be shown in the gallery (as Form will only show one record at a time), so I did try this on the Gallery: Items

But it did not display any records for it, In my SharePoint List I have created 2 records (one for Beginner Category and Intermediate), for which the TabList is creating separate tabs based on Category:

But no record is displayed as per the category. I did not get how to show data based on Category (using the Filter condition) and where to use it in tablist or in Blank Horizontal gallery which I am using to display course list as each category can have more than 1 course in it.
Also, do you know how the font-size of the tab can be increased currently it is too small and have some space between two tabs?

Regards,
Sidhant

[WiZey]

Concerning the tab control, it is kinda new and I still haven't tested it in many situations, so I suggest you experiment with it to see what you can get out of it.

About your records, you should try populating your gallery with the formula I gave you in my previous post. 

[Sidhant_02]

Hi @WiZey ,
Okay I will see the tablist widget. But regarding displaying data based on Level (Category) the expression that you had given in your reply (1st one), in which you have just mentioned only one value of Level (before it was called Category) but I am having 3 more values in Level which are Intermediate, Advanced, Expert, how will different data be shown based on the Level?.

(Used the expression which you had mentioned). 
Another thing I was trying to use a normal gallery and based on drop-down filter the values, but the issue is in drop-down I am not getting the Level column for filtering data

So the expression is: Filter(Course List, Level = Dropdown1.Selected.Level)
But the above expression is giving issue (as the expected column is not found in the Choice column value field)
{I referred the below forum answer, I am able to get the Choice column but I am not able to filter using the above expression}
Reference 

I also tried using this:

Also, when you have some time could you also have a look at one of query which was regarding security that I have posted on the Forum as well?, I have mentioned the my query link below
Block User after few invalid Attempts 
Login Using OTP 

Regards,
Sidhant

[WiZey]

The error is located on your "Level" column. I guess that's because it's still a choice-type column, which is not implicitly compatible with "StartsWith()".

"StartsWith()" expects text, however choice-type columns are seen as records. 

Using the formula I gave you earlier plus the tab/dropdown control, you should have something working with this:

Filter(
  'Courses List',
  Level.Value = tabControl.Selected.Value
)

[Sidhant_02 · Accepted solution]

Hi @WiZey ,
Thanks for the response, I tried the expression that you have mentioned, but it did not considered correct. Another thing that I observed was I had added a new record in Intermediate category for testing purpose, the tablist control was displaying the Level (choice column value) for the 2nd record as well instead it should be showing distinct values.

So I used the expression that you have mentioned on a drop-down (to filter the gallery), previously I was not able to filter the gallery, but now using your expression I could:

I did get an alternative to tablist modern control which is a manual process. I created a collection On-Start of the application which stores the Level values (choice column) in a variable using ClearCollect. Then I used 2 Horiziontal blank galleries (one to display the headers: In my case the Level values: Beginner, Intermediate, Advanced, Expert) and the other gallery to display the course information. I created another variable named 'vartabSelected' on On-Select of the header gallery to store the information of which header is selected and in the other gallery I am just comparing the choice column with Tabselected

So now only thing that is remaining that I want to make the Add new course button visible for few users (like adding a column in SharePoint list like a Role which has few choices like Admin, User. Only the Admin should be able to add new courses, others can only view) and how to make the headers look like tabs (making it look good). 
If you have some time could you please check my other queries that I have posted on the Forum
Query -1 : Login using OTP (This is 50% completed, having some few issues that I have mentioned)
Query -2 : Do not allow user to Login after few incorrect login attempts 

Please have a look at the above queries and let me know about (in their respective reply section)

Regards,
Sidhant.

[WiZey · Accepted solution]

I'm glad you resolved your first issue. As for displaying the "Add" icon to admin only, you need a method to recognize an user as a an admin.

You could either:

• Store the users in a dedicated SharePoint list
• Create a collection in "OnStart" to store all admin's email

Then in the "Visible" property of your "Add" icon, you can use this formula:

Not(IsBlank(LookUp('Table Admins', Email = User().Email)))

If the user's email is not present in the table, it means he's not an admin, resulting in a "false" statement and the icon not being displayed.

Then, to make your tabs more responsive, you can change your gallery's item's controls appearance using "ThisItem.IsSelected".

Fill: If(ThisItem.IsSelected, Blue, White)

The rest is up to your creativity.

[Sidhant_02]

Hi @WiZey ,
Thank you for the detailed response, I will definitely check this out (for the button as well as to make the tabs in the gallery more attractive).
Also did you get a chance to have a look at my other queries which I shared in my previous replies (if not I will reshare them below, please have a look at them and reply in the post there)
Query -1 : Login using OTP (This is 50% completed, having some few issues that I have mentioned)
Query -2 : Do not allow user to Login after few incorrect login attempts 

Regards,
Sidhant.

[WiZey]

Unfortunately I can't. I will be quite busy the following weeks so I won't have quite enough time to help the community. 

Try contacting a super user or an employee. Godspeed!