I have a SharePoint list that has a 'Status' field in it. The field is of Choice type and only 1 status is allowed to be selected. When I add a dropdown to my app and set the Items property to this field, I keep getting the below error, which I've never encountered before.
I've tried throwing the status into a collection and also running a distinct on the field and all code I've tried comes back with that error.
Solved! Go to Solution.
Both of those formulas expect the Status column to be a text field.
should return all 4 in the drop down. And the distinct formula should just return new and old.
However, in your case, Status is an option list. Those formulas do not work on lookup or option sets or pretty much any nested stuff. Your table is like this:
When you do 'PC Intake'.Status inside Choices, choices takes in the reference to that column. That is, it will literally get the Status Option set. More information here
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021