I want to show a default value in this Combo box based on a text field of a sharepoint list column [PM], or select a default item from the Combo box based on the text of the column [PM]. Text in column [PM] will always match one of Combo box menu "SDC-DESC" item.
I have tried lookups and filters but no luck. If I switch the [PM] column to a choice column it works, but I don't want a choice column because my choices are dynamic so I prefer simple text.
P.S. Not using Parent.Default, I am not using DataCards properly because of the complex UI I have, I am saving via Collect function all my fields.