Use Objects with a Condition in Gallery

We can design lists with a condition in the gallery by writing the If formula. With these conditions, it is possible to control a lot of features of objects like color, view, size, position. You can authorize based on person/department, hide/show buttons on the screen and highlight status in case of tracking.

Use Objects with a Condition in the Gallery

We will be going over how to show different objects for different question types in the gallery. This way, one question in the same group will be replied with the radio button and the other will be replied with rating.

Create a Collection

We will create a sample collection for an example with the data above. You need to create the collection by writing the code below into the OnSelect property of a button we will add to the screen.

ClearCollect( Questions;
{
Question:    “Question”;
Question_no:   “1”;
Question_type:    “Radio”   }
;
{
Question:    “Question”;
Question_no:   “2”;
Question_type:  “Rating”  }
;
{
Question:    “Question”;
Question_no:   “3”;
Question_type:    “Slider”   }
)

Show Objects in the Gallery

You need to add the Gallery object to the screen in order to do the action in the example. Questions collection should be connected to this gallery object’s Items.

The responding way of each question in the collection is indicated in the Question_type column. Depending on the responding way of questions, Radio Button, Rating and Slider has been added to the gallery. IF formulas will be written into the Visible property of each object and thus, the related item will be shown depending on the question type and the other ones will be hidden.

 

Radio Button Visible Code: If(ThisItem.Question_type=”Radio”;true;false)

Rating Visible Code: If(ThisItem.Question_type=”Rating”;true;false)

Slider Visible Code: If(ThisItem.Question_type=”Slider”;true;false)

 

 

You can click here to take a look at other Power Apps articles.

You can click here to take a look at the use of IF function.

 

Authorization with Department Control

You can enable interactive flow or do visual actions by creating rules in the application screen. Depending on the situation in the application scenario, you can connect objects or actions to department, user mail, location, title, marital status or user choice in multiple-choice actions.

Usually hide, show, freeze, open to edit or change color, location, size actions are done for the determined objects. You can apply all these controls in all application scenarios easily and flexibly.

Users whose department is HR will see the HR button that enables them to open the management and confirmation screen of HR.

It is better to do these actions step by step and in pieces while doing these controls. Like I mentioned in my previous article, the formula evaluations should be controlled in different labels and should be named depending on the outcome.

We will test the user department first in the example below.

Department Detection for the Existing User

We will use the Office365Users.MyProfile() formula that lets us get the existing login info of the user that opens the app for this action.

We will write the formula below in a label we named lbl_user_departmant and get the department information.

Office365Users.MyProfile().Department 

Is The Detected Department HR?

We will write the formula below into a label we named lbl_is_user_department_hr and check if the existing user is in the Human Resources department. If the user is in the HR, we will get the outcome as 1, if not; 0.

 

If the existing user is HR, what actions will be on the screen?

The Visible option of HR button will change depending on the 1/0 values that will come from the label named lbl_is_user_department_hr.

This way, the button will be showed and hidden depending on the department.

If(lbl_is_user_department_hr.Text=Value(1);true;false) 

Control Formulas

The labels named lbl_user_departmant and lbl_is_user_department_hr should be moved to the formula screen so that it is easier to revise them later. Click here to take a look at the article about creating a formula screen and its importance.

You can read about the details of the functions that are used to get user information through Office 365 here.

Similar Examples

You can do similar control with the same steps while filling a form prepared for personnel that consists of personal information like Name, Surname, ID Number, Gender, Date of Birth, Marital Status, Military Service Status.

When the gender is marked as Female, the military service status will be hidden (Visible) since it won’t be filled or it can be frozen (DisplayMode).

When the marital status is marked as single, the fields concerning spouse and children can be hidden (Visible) since they won’t be filled or they can be frozen (DisplayMode).

You can click here for other Power Apps articles.

Get a Picture from a Cell with a Formula

In this article, I want to explain you how to get a picture to a cell with a formula. As you know, we can get the data of the columns we want from a table by looking up for a value on the specified table with lookup and reference functions like VLOOKUP but we can only get the data inside a cell. At this point, what we want to tell you is that if there is a picture in the are we want to get, we can get it with a formula. By the way, we would like you to read and analyze our articles about Office, you can find them on our blog.

 

Get a Picture to the Cell with a Formula

Let’s say that we have two different pages. On one page, there are products, brand names etc. and on the other page there are product and brand pictures. We can get the picture on the second page next to the product and brand name on the first page with a formula that we’ll write. While doing that, as you’ll see below, we need to define names. We cannot get the picture in a cell without defining names.

 

Here is how you do it step by step:

  • Create a Data Verification list with brands.
  • Write the main formula necessary for this action.
  • Name the formula we created with the Name Manager.
  • Complete the process by assigning the name to the picture.

 

Let’s start understanding how to do it with pictures! 😀

We talked about creating a data verification list first, let’s take a look at it.

veri doğrulama listesine almak

 

We took the brand names to the data verification list.Let’s write the formulas that will do the job. I am leaving the formula here, you can see how I write it in the gif below. 

=İNDİS('6-1'!$B$2:$B$6;KAÇINCI('6'!$A$2;'6-1'!$A$2:$A$6;0))

 

formülle resim getirme formülü

 

Now we’ll name the formula I have written, assign the picture on the first page and complete this action.

 

formüle ad verme

 

As you can see, we have learned how to get a picture to a cell with a few steps.. We have called a picture on another page to the active page with brand names. You can execute this kind of examples by getting pictures dynamically.

Also, you can get more information about defining names on Microsoft Support.

 

See you in other articles, bye.🙋🏻‍♂️
You can share this post with your friends and help them get informed. 👍🏻