Hi Everyone, for context
the formula i created on the datacard is showing as a default item but not being inserted to my database which is the sharepoint lists.
seqNum: primary key from (main table)
seqNumRef: lookup column from another table (table2)
galPreProScreen: is my gallery item
here's the design and the formula for defaultselecteditems:
my formula in the items (same datacard):
but not being fetched to my sharepoint list:
@deo13adel - as I understand it, the output displayed in the DefaultSelectedItems property of that ComboBox control is not being saved back to the "seqNumRef" field in your SharePoint list (I assume this field been configured as single-select).
In the Items property, I would have expected:
Filter(
Choices([@'DRS_main'].seqNum),
Id = galPreProScreen.Selected.seqNum
)
In the DefaultSelectedItems property:
Parent.Default
Nothing else should be modified from the default set up for that DataCard.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional