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 · Accepted solution]

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

[Khole]

Thank you once again. 

on my powerapps, the selected option from a dropdown list does not show on my view screen.

[StalinPonnusamy]

Hi @Khole 

I assume you are using the form to display data on the view screen.

For the Combo box, Set the DefaultSelectedItems property of Datacardvalue to Parent.Default.

If you use Label control to display the dropdown(Choice) value then Set Text property to 

ThisItem.ChoiceColumn.Value

Thanks,
Stalin - Learn To Illuminate

[Khole]

Thank you for always replying.

I am not using a Label and my Default selected items is on that already

For my Items property, Office365Users.SearchUser({ searchTerm:"Mail"}) is what i used.

Maybe that could help you help me. 

[StalinPonnusamy]

Hi @Khole 

Can you try this

{
    Claims: "i:0#.f|membership|" & ThisItem.'PersonColumnName'.Email,
    Department: "",
    DisplayName: ThisItem.'PersonColumnName'.DisplayName,
    Email: ThisItem.'PersonColumnName'.Email,
    JobTitle: "",
    Picture: ""
}

[Khole]

As the Item property?

[StalinPonnusamy]

As DefaultSelecteditems property

[Khole]

Still having the same issue.

I think i am having this issue because i customized the item property. Reason is i added a new field with the original item property and i got a display