cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Victormartal
Regular Visitor

Slicer to input data

Hello community,

 

I've been diging into the power apps and testing it for a new project I'm assgined to, and I would like to know if it's possible to use slicers to write data back to excel.

I am working on a form to input values from a wine tasting, currently they are using another software which allows to input the different values they measure using slicers. Would it be possible to use it in power apps?

I've seen it used as a filter, but couldn't find examples or info on how to use it as an input.

 

Thanks for your time and help, have a nice week!

2 ACCEPTED SOLUTIONS

Accepted Solutions
rubin_boer
Super User
Super User

hi @Victormartal yes you can do that.

Define variables for your ranges on the screens OnVisible event:

UpdateContext({__WineTest1Min:0; __WineTest1Max:100})

Min = __WineTest1Min

Max = __WinTest1Max/10

rubin_boer_0-1612786491306.png

Value = (Slider.Value)/10

Set the ShowValue to Off

 

You can do decimals this way with a scale from 0 to 1 etc.

 

Hope this is what you looking for ;).

 

 

 
 

View solution in original post

rubin_boer
Super User
Super User

Hi @Victormartal you have two options to do that, static data where you upload your excel spreadsheet

rubin_boer_0-1612797098230.png

 

or via OneDrive which i suspect you will use.

rubin_boer_1-1612797135955.png

 

Then you have your Excel Data in Power apps. 

 

Hpe this will help

 

 

 

View solution in original post

7 REPLIES 7
rubin_boer
Super User
Super User

hi @Victormartal 

rubin_boer_0-1612780803830.png

 

If this is what you look for

 

Add sliders as many as you need. The label = SliderName.Value

in the OnChange event of the slider as a local variable if that will help UpdateContext({__WineTest1:Value(Slider1.Value)}) 

 

When you save your data the values from the sliders are saved.

 

Hope this is what you looking for.

 
 
rubin_boer
Super User
Super User

hi @Victormartal , will this work for you?

 

Awesome! Does that mean that I would define the possible values for my question/parameter using the slider? I don't find a way to edit the values and their division. I mean I can assign a min and a max, but the values are numerical and 1 by 1 right? Can't be decimals?

 

Thanks again 😃

rubin_boer
Super User
Super User

hi @Victormartal yes you can do that.

Define variables for your ranges on the screens OnVisible event:

UpdateContext({__WineTest1Min:0; __WineTest1Max:100})

Min = __WineTest1Min

Max = __WinTest1Max/10

rubin_boer_0-1612786491306.png

Value = (Slider.Value)/10

Set the ShowValue to Off

 

You can do decimals this way with a scale from 0 to 1 etc.

 

Hope this is what you looking for ;).

 

 

 
 

View solution in original post

Victormartal
Regular Visitor

Thanks! I've been trying to do it, although I can't connect the slider with my columns on the excel spreadsheet, is it possible?

Thanks!

rubin_boer
Super User
Super User

Hi @Victormartal you have two options to do that, static data where you upload your excel spreadsheet

rubin_boer_0-1612797098230.png

 

or via OneDrive which i suspect you will use.

rubin_boer_1-1612797135955.png

 

Then you have your Excel Data in Power apps. 

 

Hpe this will help

 

 

 

View solution in original post

Thanks! I saw that the problem is that power apps doesn't recognise the different data types of my columns, so when I try to edit them I can only use them as text.

I tried changing the data type in my excel spreadsheet, but doesn't work. I would like to have number data type and binary. 

 

I guess in all the tutorial I've seen they work with databases, so they define the type for each column, whereas in excel it doesn't work, does that makes sense?

 

Thanks, you're helping me a lot ^^

Helpful resources

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

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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