Answered

ComboBox not populating data correctly

(0) Share

Report

Posted on by Jandal_Power

101

The intention of the ComboBox is to automatically pull through the display name of the user signed into the app.
The user has the option to change the ComboBox to another users name, it is searchable.

The issue I am experiencing is, if the name is automatically filled in, nothing comes up when its patched through.
If you select any user in the company, even yourself, then the data shows up.
Why does the Automatic name pull through as blank?

Is it the way I am patching the data?

If(
 !IsBlank(ComboBox1.Selected) &&
 !IsBlank(TextInput3.Text),
 Set(
 varRecordID,
 Patch(
 'IFP - PPE Cart Orders',
 Defaults('IFP - PPE Cart Orders'),
 {
 Requestor: ComboBox1.Selected,
 Title: TextInput2.Text,
 'Order Comments': TextInput3.Text,
 'Order total': Sum(colPPECart, SubTotal)
 }
 ).ID
 );
 Collect('IFP - PPE Cart Ordered Items', AddColumns(colPPECart, OrderID, varRecordID ));
 Clear(colPPECart);
 Notify("Submission Successful", NotificationType.Success, 2000);
 Navigate(scrPPEHome),
 Notify("Please fill in all required fields.", NotificationType.Error, 2000)
)

Is it because I used ".Selected"? and it is not a selection?
I populate the name by...
On ComboBox - DefaultSelectedItems -

{
 DisplayName: Office365Users.MyProfile().DisplayName,
 UPN: Office365Users.MyProfile().UserPrincipalName
}

Cheers 😂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Kuhlani 82 on at

Like (1)

Report
Copy link

Link copied!
Your use of .Selected is correct. The issue seems to be a mismatch in the schema of the person object since your DefaultSelectedItem does not match the object SharePoint is expecting. Try this:

Change the Items property of the combo box to:
Choices('IFP - PPE Cart Orders'.Requestor)

And the DefaultSelectedItem to:
{ Claims: $"i:0#.f|membership|{Lower(User().Email)}", Department: "", DisplayName: User().FullName, Email: Lower(User().Email), JobTitle: "", Picture: "" }

Was this reply helpful? Yes No
VishalJhaveri 1,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
{ Claims: $"i:0#.f|membership|{Lower(User().Email)}", Department: "", DisplayName: User().FullName, Email: Lower(User().Email), JobTitle: "", Picture: "" }
Person type of column patches in a different method. Please try the above piece of code. Also if you need any help in the CRUD Operations using PATCH, refer this 5 part blog series.
Master CRUD Operations in Power Apps : Part 4 (inkeysolutions.com)

Was this reply helpful? Yes No
Jandal_Power 101 on at

Like (0)

Report
Copy link

Link copied!

This worked perfectly. Thank you very much. I have much to learn 😀

Was this reply helpful? Yes No
Jandal_Power 101 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much. I will give this a read 😊

Was this reply helpful? Yes No