ComboBox

[Khole]

I am trying to create a custom form connected to a list on sharepoint. I have 3 fields that I need the user to fill in email, but i want to pull it out from Office365 Users. How do i go about this? Note that i have already tried using 'Office365Users.SearchUser({searchTerm:ComboBox11.SearchText,top:10})' in the item property but i still domt get a dropdown list of users.

[StalinPonnusamy]

Hi @Khole 

Set the Items property of Combobox to

Office365Users.SearchUser({searchTerm: ""})

Set Layout as a person

[Khole]

It still does not give me the dropdown of users. I'm only able to type.

[StalinPonnusamy]

Hi @Khole 

It should have both. Are you using the Combobox inside the form (Data card) right?

The dropdown will not give full flexibility to get a person's record. This is only the main difference between dropdown and combo box.

[Khole]

Yes the ComboBox is a part of the card. 

So what should i do?

What i want to achieve is a situation where upon typing a letter, options are provided in the dropdown to be selected

[StalinPonnusamy]

Hi @Khole 

Allow searching

[StalinPonnusamy]

Hi @Khole 

Does the solution work for you? Please let me know if any questions.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Thanks,
Stalin - Learn To Illuminate

[Khole]

Hey, do you know if its possible to have a dropdown list of departments, i do not want to manually add each department to the Sharepoint dropdown list as it is quite the number of departments. So maybe having Powerapp pull it out from an excel sheet or something. 

kindly reply @StalinPonnusamy.

[StalinPonnusamy · Accepted solution]

Hi @Khole 

We can get a list of departments from Office365 users. Set the dropdown Items property to

Distinct(
   Filter(
      Office365Users.SearchUser(),
      Len(Department) > 0
   ),
   Department
)

You can also store the Departments in the SP list and retrieve them. Set the Items property of dropdown to

Sort(Distinct(SPList,ColumnName),Result)

[Khole]

CAN YOU HELP  WIT POWER AUTOMATE?

Hello,

i created a PowerApp form and I need to create a flow that does the flowing please. 

1. Sends out an email to person filling the form, that his/her request is pending approval from the Line Manager at the same time sends to the LM for his approval

2.After the LM approves, and email should be sent to the Requester that his request has been approved by the Line Manager and is pending approval from the Approver 1 and also a mail should be sent to Approver 1 for his approval

3. After the Approver 1 approves, and email should be sent to the Requester that his request has been approved by the Approver 1 and is pending approval from the Approver 2 and also a mail should be sent to Approver 2 for his approval

4. After the 3 must have approved, it should then be sent to  an ENtity CEO for approval.

    a. if cost(a card on the form) is > 50,000 and Entity(another card) = OER, then,email should be sent to a particular person for approval 

kindly help with step by step processe