Solved: ComboBox

Khole · ‎10-20-2021

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 · ‎10-22-2021

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)

View solution in original post

StalinPonnusamy · ‎10-25-2021

Hi @Khole

There is a lot of steps on this requirement. Let me try to direct you to the right path to start, this will help you to build it more.

Type "Automated Cloud Flow"
Search 'SharePoint"
Trigger "When an item is created or modified"

Here is the flow look like

If Yes and If No expanded from the above image

You can extend this to Approver 3 and CEO
Need to make sure this flow only will be triggered when the condition is met. It means some status or something instead of all the time.

Let me know what condition this email approval should be kicked off. For example, approval start when the status is completed in the below example

@equals(triggerOutputs()?['body/status_label'],'completed')

Click "..." three-dot
Click Settings
Set the Trigger condition based on your requirement

Thanks,
Stalin - Learn To Illuminate

View solution in original post

StalinPonnusamy · ‎10-20-2021

Hi @Khole

Set the Items property of Combobox to

Office365Users.SearchUser({searchTerm: ""})

Set Layout as a person

Khole · ‎10-20-2021

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

StalinPonnusamy · ‎10-20-2021

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 · ‎10-20-2021

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 · ‎10-20-2021

Hi @Khole

Allow searching

StalinPonnusamy · ‎10-21-2021

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 · ‎10-22-2021

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 · ‎10-22-2021

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 · ‎10-25-2021

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