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

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

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.

Top Solution Authors
Top Kudoed Authors
Users online (1,534)