User Profile
ravanwijk
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Passing form data that is defined in combobox defaultselecteditems
I have created a form that is connected to a Sharepoint list called: "Win" The Sharepoint list holds a.o. a multiselect column called 'Solution Category' I have a multiselect combobox (cmbSolCat_1) that is part of this form. - The combobox items list gets its data from an single column excel table called SolutionCat - The headername of the table is called 'Customer Solution' The defaultselecteditems property of this combobox is defined as: ThisItem.'Solution Category' - The datacard Update property is:ForAll(cmbSolCat_1.SelectedItems, {Value:'Customer Solution'}) All of the above works well if I select some of the items in the multiselect combobox. If I would edit an existing entry, with multiple items selected, it would show me those items. If I now would submit my form with no changes, it will not pass the items that were listed from the defaultselected property. Instead, it will blank out all everything in that cell of the sharepoint list. Appreciate your insight on how to pass on defaultselecteditems in a multiselect combobox.Powerapp Sharepoint based form with drop-down using excel table items
I have created a SharePoint list with a.o. Choice columns. One of those columns is called GTM. Linking this table to a powerapp form works well and the GTM datacard is shown as a drop-down item. All ok. Now I want this drop down to be linked to an excel table, called GTM_Ex. That also worked out fine. Now when I submit the form, the selected value is not passed to the SharePoint table. The datacard Update is pointing to the drop-down datacardvalue. Alternatively, I removed the drop down and inserted a new (classical) drop down item in the datacard. Linked it to the excel. Made sure Update of datacard is pointing to its selected value…but again, selected value of the drop down did not pass to the SharePoint after an updateform command. anyone any idea?Re: SUMIFS with OR Logic and spilling results
OliverScheurichthanks for your reply. Yes, this works. I have even worked out such formula myself based on SUMIFS in array formula: ={SUM(SUMIFS(dB[Value],dB[Month],$B9,dB[Region],C$8,dB[Forecast],$C$2:$C$4))} However, instead of using this approach by populating every cell, I was wondering whether there is a way to use the spill functionality. I.e. only type 1 formula and then the whole table is spilled with the results.4.2KViews0likes1CommentSUMIFS with OR Logic and spilling results
Hi, I am looking for a way to design a formula that can fill a table by spilling the result. The formula is composed of a sum that requires to meet certain conditions (Logic AND + Logic OR). Once I start introducing Logic OR into it, things no longer work, since the usual setup of such formula would be SUM(SUMIFS(.....)): this formula no longer spills the results. Attached is an example file. The table is composed of months to the left and regions at the top. The data for the formula to look into is in the "Data" sheet. The OR logic condition is defined at the top of the table. In this case, the formula has to satisfy (amongst others) those entries that satisfy the forecast condition of "Risk" OR "Secure" OR "Upside". The forecast conditions are dynamic, as such, the formula requires to have OR Logic using cell references. Appreciate your view / help!Solved4.3KViews0likes6Comments
Groups
Recent Blog Articles
No content to show