Unanswered

Using circle colour to indicate whether something is submitted or not

(1) Share

Report

Posted on by Melissa33

Hi,

I have a SharePoint list that stores forms that have been submitted, each form submission is linked to an ID that is Autogenerated in one of the other lists. There are 4 types of form, these forms are put into a gallery that is going to be filtered by the admission selected and if 1 or more of the forms aren't submitted I want to use the colour of the circles in the virticle gallery to indicated that (Green for submitted and Red for not submitted) and for teh colour to be updated once the form is submitted I was wondering if there was a way to do this I have tried using an IF statement but it doesn't work because I was unsure how to format it.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Check this example:

In a blank Canvas App:

1) Place a Text input field

2) Place an Icon (Circle Icon in this example)

On the Fill Attribute of the Icon, place this Formula:

If(TextInput1.Text = "1",Red, If(TextInput1.Text = "2",Green, If(TextInput1.Text = "3",Blue, If(TextInput1.Text = "4",Yellow))))

3) Try the app and change value to 1, 2, 3, 4 and it works to change to 4 different colors based on the nested If Formula.

See if you can adapt above simple example to your scenario.

Was this reply helpful? Yes No
Melissa33 34 on at

Like (0)

Report

Also was wondering, I have added a text box over the circle and it is meant to count the number of forms submitted based on the form type and the admission ID.

This is the formula I have been using however it only counts 2 for one of the forms when there are 4 submissions under that submission ID for that type of form
Count(Distinct(Filter(nestForms, Title=Title7.Text), AdmissionsID))

Title is the Form type and Title7.Text is the name of the form which is listed in a gallery (if that makes sense)

Was wondering if you could help me out.

Was this reply helpful? Yes No