Share
Report
5,331I finally got a method that works. Below is the Patch I am using to add data to my SharePoint list.
Also shown is the Gallery and Combo Boxes which are the source of the Patch content.
The user can toggle one of three options, which reveal three of nine Combo Boxes at a time, depending on which item is chosen in the toggle.
The user can only enter data into one of the set of three. One data is entered the toggle is 'disabled'.
It is unknown which option the user will choose. I need the ability to be able to get the data from all nine Combo Boxes.
The formula I have gets me the first three Combo Boxes.
How do I edit the formula so that each line looks at the contents of three of the Combo Boxes (I have the order) and Patches the contents of the one or three with data without overwriting it null value from the other two?
Patch(
'Test List',
Defaults('Test List'),
{Title: ReviewCompanyNameFLd_2.Text},
{CollectorName: User().FullName},
{DateOfEvent: ReviewDateOfEventDatePicker.SelectedDate},
{CompanyName: ReviewCompanyNameFLd_3.Text},
{PotentialClassification: ReviewPotentialClassificationCB_1.Selected.Value},
{PSMCategoryType: PSMReviewCategoryTypeFld.Text},
{PSMImmediateNeed: PSMReviewImmediateNeedCheckbox.Value},
These are the items in question. I need to be able run each line out 'Concat' to account for the content of three Combo Boxes returning and Patch the content of the Combo Box that actually has data and ignoring the two blank Combo Boxes.
{PSMCCCategoryCommodity: Concat(PSMCatComCatComCB.SelectedItems, Result & "; ")},
{PSMCCProcurementProfessional: Concat(PSMCatComProProfCB.SelectedItems, Result & "; ")},
{PSMCCPurchasingGroup: Concat(PSMCatComPurchGrpCB.SelectedItems, Result & "; ")},
Form2.Updates
);
All responses (
Answers (
