Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Error Handling / Patching a combobox em...
Power Apps - Error Handling
Suggested answer

Patching a combobox email to Sharepoint lists people column

(1) ShareShare
ReportReport
Posted on by PowerAppsGuy 10
Reviewer is a people column in sharepoint lists, none of the code seems to be working when trying to patch the combobox to sharepoint lists 
 
I need help with the following code: 
 
ForAll(
    FilteredExpectations,
    Patch(
        STEvE,
        Defaults(STEvE),
        {
           
           
Reviewer:
    Lower(ComboBox3.Selected.Mail), //error code
I have also tried: 
 
Here is the full code:
 
'Reviewer': {
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims: "i:0#.f|membership|" & Lower(ComboBox3.Selected.Mail),
    DisplayName: ComboBox3.Selected.DisplayName,
    Email: ComboBox3.Selected.Mail,
    Department: ComboBox3.Selected.Department,
    JobTitle: ComboBox3.Selected.JobTitle
}
 
ForAll(
    FilteredExpectations,
    Patch(
        STEvE,
        Defaults(STEvE),
        {
           
           
Reviewer:
    Lower(ComboBox3.Selected.Mail),
 
 
            Team: Dropdown1.Selected.Value,
            Comparison: Dropdown1_3.Selected.Value,
            SubTeam: Dropdown1_1.Selected.Value,
            RoleLevel: Dropdown1_2.Selected.Value,
            Title: TextInputCanvas1.Value,
           
 
            Expectation1: If(CountRows(Gallery4_1.AllItems) >= 1, Index(Gallery4_1.AllItems, 1).Dropdown2_1.Selected.Value, Blank()),
            Expectation2: If(CountRows(Gallery4_1.AllItems) >= 2, Index(Gallery4_1.AllItems, 2).Dropdown2_1.Selected.Value, Blank()),
            Expectation3: If(CountRows(Gallery4_1.AllItems) >= 3, Index(Gallery4_1.AllItems, 3).Dropdown2_1.Selected.Value, Blank()),
            Expectation4: If(CountRows(Gallery4_1.AllItems) >= 4, Index(Gallery4_1.AllItems, 4).Dropdown2_1.Selected.Value, Blank()),
            Expectation5: If(CountRows(Gallery4_1.AllItems) >= 5, Index(Gallery4_1.AllItems, 5).Dropdown2_1.Selected.Value, Blank()),
            Expectation6: If(CountRows(Gallery4_1.AllItems) >= 6, Index(Gallery4_1.AllItems, 6).Dropdown2_1.Selected.Value, Blank()),
            Expectation7: If(CountRows(Gallery4_1.AllItems) >= 7, Index(Gallery4_1.AllItems, 7).Dropdown2_1.Selected.Value, Blank()),
            Expectation8: If(CountRows(Gallery4_1.AllItems) >= 8, Index(Gallery4_1.AllItems, 8).Dropdown2_1.Selected.Value, Blank()),
            Expectation9: If(CountRows(Gallery4_1.AllItems) >= 9, Index(Gallery4_1.AllItems, 9).Dropdown2_1.Selected.Value, Blank()),
            Expectation10: If(CountRows(Gallery4_1.AllItems) >= 10, Index(Gallery4_1.AllItems, 10).Dropdown2_1.Selected.Value, Blank()),
            Expectation11: If(CountRows(Gallery4_1.AllItems) >= 11, Index(Gallery4_1.AllItems, 11).Dropdown2_1.Selected.Value, Blank()),
            Expectation12: If(CountRows(Gallery4_1.AllItems) >= 12, Index(Gallery4_1.AllItems, 12).Dropdown2_1.Selected.Value, Blank()),
            Expectation13: If(CountRows(Gallery4_1.AllItems) >= 13, Index(Gallery4_1.AllItems, 13).Dropdown2_1.Selected.Value, Blank()),
            Expectation14: If(CountRows(Gallery4_1.AllItems) >= 14, Index(Gallery4_1.AllItems, 14).Dropdown2_1.Selected.Value, Blank()),
            Expectation15: If(CountRows(Gallery4_1.AllItems) >= 15, Index(Gallery4_1.AllItems, 15).Dropdown2_1.Selected.Value, Blank()),
            Expectation16: If(CountRows(Gallery4_1.AllItems) >= 16, Index(Gallery4_1.AllItems, 16).Dropdown2_1.Selected.Value, Blank()),
            Expectation17: If(CountRows(Gallery4_1.AllItems) >= 17, Index(Gallery4_1.AllItems, 17).Dropdown2_1.Selected.Value, Blank()),
            Expectation18: If(CountRows(Gallery4_1.AllItems) >= 18, Index(Gallery4_1.AllItems, 18).Dropdown2_1.Selected.Value, Blank()),
            Expectation19: If(CountRows(Gallery4_1.AllItems) >= 19, Index(Gallery4_1.AllItems, 19).Dropdown2_1.Selected.Value, Blank()),
            Expectation20: If(CountRows(Gallery4_1.AllItems) >= 20, Index(Gallery4_1.AllItems, 20).Dropdown2_1.Selected.Value, Blank()),
            Expectation21: If(CountRows(Gallery4_1.AllItems) >= 21, Index(Gallery4_1.AllItems, 21).Dropdown2_1.Selected.Value, Blank()),
            Expectation22: If(CountRows(Gallery4_1.AllItems) >= 22, Index(Gallery4_1.AllItems, 22).Dropdown2_1.Selected.Value, Blank()),
            Expectation23: If(CountRows(Gallery4_1.AllItems) >= 23, Index(Gallery4_1.AllItems, 23).Dropdown2_1.Selected.Value, Blank()),
            Expectation24: If(CountRows(Gallery4_1.AllItems) >= 24, Index(Gallery4_1.AllItems, 24).Dropdown2_1.Selected.Value, Blank()),
            Expectation25: If(CountRows(Gallery4_1.AllItems) >= 25, Index(Gallery4_1.AllItems, 25).Dropdown2_1.Selected.Value, Blank()),
            Expectation26: If(CountRows(Gallery4_1.AllItems) >= 26, Index(Gallery4_1.AllItems, 26).Dropdown2_1.Selected.Value, Blank()),
            Expectation27: If(CountRows(Gallery4_1.AllItems) >= 27, Index(Gallery4_1.AllItems, 27).Dropdown2_1.Selected.Value, Blank()),
            Expectation28: If(CountRows(Gallery4_1.AllItems) >= 28, Index(Gallery4_1.AllItems, 28).Dropdown2_1.Selected.Value, Blank()),
            Expectation29: If(CountRows(Gallery4_1.AllItems) >= 29, Index(Gallery4_1.AllItems, 29).Dropdown2_1.Selected.Value, Blank()),
            Expectation30: If(CountRows(Gallery4_1.AllItems) >= 30, Index(Gallery4_1.AllItems, 30).Dropdown2_1.Selected.Value, Blank()),
            Expectation31: If(CountRows(Gallery4_1.AllItems) >= 31, Index(Gallery4_1.AllItems, 31).Dropdown2_1.Selected.Value, Blank())
        },
    {Status: "Draft"}
    )
   
);

 
 
  • PowerAppsGuy Profile Picture
    PowerAppsGuy 10 on at
    Patching a combobox email to Sharepoint lists people column
  • MS.Ragavendar Profile Picture
    MS.Ragavendar 2,210 on at
    Patching a combobox email to Sharepoint lists people column
     
    Is it single value or multi value?
     
    Can you please share the screen design on the form.
  • PowerAppsGuy Profile Picture
    PowerAppsGuy 10 on at
    Patching a combobox email to Sharepoint lists people column
     
    This doesn't work, I am getting the following errors: 
    The type of this argument 'Reviewer' does not match the expected type 'Record'. Found type 'Text'.
    Name isn't valid. 'Selectedi' isn't recognized.
  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 2,210 on at
    Patching a combobox email to Sharepoint lists people column
     
    I understood (Reviewer) is sharepoint person or group column.
     
    Instead of this  Power Fx formula
     
    Reviewer:
        Lower(ComboBox3.Selected.Mail),
     
    Just give this alone 
     
    Single Person
     
    Reviewer: ComboBox3.Selected
     
    Multi Person (Column)
     
    Reviewer: ComboBox3.SelectedItems
     
     
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
    ✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans