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 / SharePoint List Custom...
Power Apps
Answered

SharePoint List Customized PowerApps Form - Lookup columns

(0) ShareShare
ReportReport
Posted on by 995

I have a customized SharePoint form using PowerApps.  I've got a couple of questions:

  1. What is the Limit on Lookup columns in a PowerApps?  I believe I saw someplace that said 12, so does that include everything except for a single text column?
  2. I need to be able to have multiple people (@8 people) vote "Yes" or "No" (I'm using a toggle) and a Person field for each (or should I use a Text field and have the user enter an email address?).  I have 6 other types of fields (Choice and Y/N).
  3. I thought about using checkboxes for each of the 8 people and capture it that way, ideas?
Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @kmw1130 ,

     

    1. LookUp columns include LookUp and Person columns only.

    2. Since you are using customize form, you can have 8 Y/N columns as well as 8 Text columns where save Emails. But in customize form, you will be able to custom the control to replace default Text Input box with a Combo box, let users to be able to search from O365 and update the Email of a selected user in the Combo box.

    3. Also in the custom form, you can change default toggle control with a Check box.

     

    For 2&3, you need to change the Update property of each Data Card that bounds to respective column, to be ComboBox.Selected.Email or CheckBox.Value. Items property of Combo boxes, which is also known as the data source of the Controls, should be Office365Users.SearchUser({searchTerm: Self.SearchText, top:20}). Furthermore, you will also need to change Default and DefaultSelectedItems property of each Combo Box or Checkbox, make sure in edit mode these control would get correct values from the list and display in these control.

     

    When making the App, if you encounter any problem, you can search the answer to it in this forum. If can't find any, you can also post the issue as a new question here, users in the community would be glad to help.

     

    Best regards,

  • kmw1130 Profile Picture
    995 on at

    @v-jefferni Thank you.  I will give this a try and will post if I have any issues.

  • kmw1130 Profile Picture
    995 on at

    @v-jefferni What did I need to add to the defaultSelectedItems for the Office365userscombobox?

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

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard