web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Fin )365 user Combi Bo...

Power Apps

Answered

Fin )365 user Combi Box To list

(0) Share

Report

Report

Posted on by Aliwells632

Hello Im looking to patch a new entry and have done all fields except the 2 combo Boxes i have that are set to a O36User search(Office365Users.SearchUser({searchTerm:cb_AuthOff.SearchText,top:10}))

The Patch Im trying to use is - Patch('Cargo Request',Defaults('Cargo Request'),
{'SNCO Approval Email':cb_AuthOff.Selected.Mail});

I have a whole patch working that i just need to add the email strings to.

Also is there any specific setting i should have my column on in my list to make it easier?

List Name -Cargo Request

Column Name - SNCO Approval Email

Combo box Name- cb_AuthOff

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Aliwells632

I'm not entirely sure I understood your request, but here's my best guess at an example:
Patch('Cargo Request', Defaults('Cargo Request'), {'SNCO Approval Email': If( IsBlank(cb_AuthOff.Selected), "", cb_AuthOff.Selected.Mail ), // include other fields you want to patch});

So first we check if a user is selected in the combo box by using the IsBlank function. If the combo box is blank, set the email field to an empty string. If a user is selected, set the email to the selected user's email using the Selected.Mail property.

For the "SNCO Approval Email" column in your SharePoint list, it should be set to "Single line of text" because the email address is a text string.

Was this reply helpful? Yes No

Join the conversation