You’re offline. This is a read only version of the page.
Announcements
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
Hi @Aliwells632
I'm not entirely sure I understood your request, but here's my best guess at an example:
Share
Report
All responses (
Answers (
1,369
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.
