Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Change Icon Color based on Inserted Number Value by user connected to excel data source

Hi Experts,


Really appreciate your help on this.


Got a quick question - I have created a survey based on the below excel data source (attached chart). Is there a way to connect:


1. First page: When dropdown menu selected value = 1, Annual volume number value input = 700 which is > 500 (from excel data source)--> clicks submit and leads to second page with icon changes to green light/if lower than 500 changes to red light


And same goes for when selected value = LOB 2 or 3 and with respective total volume from excel data source 


Please let me know if there's any solutions to make this work! Thanks!


Excel data source:



First page:


When click 'submit' button, it will link to second page.


Second page:




@CNT it will be here on the results page



@aurora12234 If you click on the code with the Red lines, it will tell you what the error is. Can you share a picture of that.

View solution in original post





@aurora12234 Got it!


We're missing a comma (,) at the end of the First Line in the code.

@CNT Its working now! Thank you so much for your help!

@aurora12234 At last!

I deserve a tons of 👍 for this!!!

Please remember also to accept the solution as it will help others in the future.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,841)