web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Choices and Yes/No col...
Power Apps
Suggested Answer

Choices and Yes/No columns in collections

(0) ShareShare
ReportReport
Posted on by 581
I'm trying to put this datasource column into a collection. I am using the dataverse as my datasouce
Set(varName, ShowColumns(LookUp('datasourceName', 'datasourceFilterColumn' = dataId), isReady, Days, Name, Location));

the columns Name and Location appear as I need

however isReady is a yes/no column and Days is a choices column and both appear as question marks

How do I get the value of those columns into my collection instead of the question marks?
Thanks in advance
I have the same question (0)
  • Suggested answer
    ronaldwalcott Profile Picture
    3,906 Moderator on at
    You can try something similar to 
     
    Set (varName, ShowColumns(AddColumns('Job Descriptions', theDepartmentName, Text(Department)), cr836_jobtitle, theDepartmentName));
     
     
    I have no idea why this works but it also appears to require you to use the logical name of the other columns which you want to include.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 477

#2
WarrenBelz Profile Picture

WarrenBelz 341 Most Valuable Professional

#3
11manish Profile Picture

11manish 317

Last 30 days Overall leaderboard