I am trying to create drop down box in PowerApps that will have the numbers from 1 to 10. I want a user to select a number and the next screen would have the x amount of rows the user picked. so they can fill in data.

I've created a table named NumOfDocs with a column called DocNum and it has a list starting from 1 down to 10. I added the data source to PowerApps and used the formula Distinct(NumOfDocs, DocNum) but I get an error that reads:

The property expects a Number value, but this rule produces incompatible Table values.

I'm new to PowerApps and not sure why I'm getting this error. I looked up everywhere online but could only find examples of strings and not numbers.

Thanks in advance.

1 Answer 1


Actually, it works like this. I've created a data source as you said.

enter image description here

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.