cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aurora12234
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:

aurora12234_3-1622622524152.png

 

First page:

aurora12234_2-1622622439758.png

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

 

Second page:

aurora12234_1-1622622097964.png

 

15 REPLIES 15

@CNT it will be here on the results page

aurora12234_0-1622648081554.png

 

@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

@CNT 

aurora12234_0-1622648803218.png

aurora12234_1-1622648863166.png

 

@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

Announcements
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)