cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ralf89
Frequent Visitor

Set Default for Combo box from a SP list text field

Hi,

I have a Combo box populated with a column from a collection:

Items:

SortByColumns(ShowColumns(Filter(tSDCODES,'SDC-TYPE'="LM"&&'SDC-STAT'="A"),"SDC-DESC"),"SDC-DESC",Ascending)

 

  • 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.

 

Thanks a lot

1 ACCEPTED SOLUTION

Accepted Solutions
ralf89
Frequent Visitor

Unbelieveble after hours of trying I decided to post for help and few min later I figure it out LOL, if anyone is interested. Filter using the DefaultSelectItems:

Search(Combo box source, Items:, Search criteria (in my case text column ThisItem.PM), "Combo box source column")

Search(SortByColumns(ShowColumns(Filter(tSDCODES,'SDC-TYPE'="LM"&&'SDC-STAT'="A"),"SDC-DESC"),"SDC-DESC",Ascending),ThisItem.PM,"SDC-DESC")

 

View solution in original post

1 REPLY 1
ralf89
Frequent Visitor

Unbelieveble after hours of trying I decided to post for help and few min later I figure it out LOL, if anyone is interested. Filter using the DefaultSelectItems:

Search(Combo box source, Items:, Search criteria (in my case text column ThisItem.PM), "Combo box source column")

Search(SortByColumns(ShowColumns(Filter(tSDCODES,'SDC-TYPE'="LM"&&'SDC-STAT'="A"),"SDC-DESC"),"SDC-DESC",Ascending),ThisItem.PM,"SDC-DESC")

 

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,354)