cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver I
Resolver I

Dropdown from another table in Form giving a Value error

Hello,

 

So I need to access a column from another table inside a form as a dropdown. (Basically, so each value is distinct)

The thing is it works perfectly - the column values display - if I'm editing the App and press the 'play' button but if I open it directly I get an error;

"The requested operation is invalid. Server Response: The column 'Value' of the table wasn't found. inner exception: The column 'Value' of the table wasn't found".

 

Any help is appreciated,

Thank you.

 

EDIT: Alternatively is there a way I can get only distinct values from a column into a dropdown? ('Distinct' doesn't work)

1 ACCEPTED SOLUTION

Accepted Solutions
Resolver I
Resolver I

Found a solution, hopefully just a temporary one, basically if you want a dropdown to work in a form make sure you unselect this in App settings > Advanced Settings
res.PNG 

Everything runs slower as a result but atleast it works.

View solution in original post

3 REPLIES 3
Super User II
Super User II

Hi Conner,
Try replacing Value in your formula with Result and see if that works.

Thanks for the reply, but this didn't work, I think the problem lies with the dropdown being unable to get the column value for some reason.

 

If I navigate to the form by pressing the 'Play' button inside editing the app I get :

drop2.PNG

But if I navigate to the form by just pressing the 'Play' button from the PowerApps homepage i get:

drop1.PNG

The Column values arent found, and the error shows up.

 

The 'items' value is "Distinct('[autmeasures].[Measure_Configuration]', Measure_Group_Code)" (I managed to get Distinct to work) but the error happens regardless - with or without the distinct filter.

 

Any ideas? 

Thanks for your help

Resolver I
Resolver I

Found a solution, hopefully just a temporary one, basically if you want a dropdown to work in a form make sure you unselect this in App settings > Advanced Settings
res.PNG 

Everything runs slower as a result but atleast it works.

View solution in original post

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,803)