How to split the values in combobox

[preethi1_suresh]

while I am fetching data from Fin & ops in power apps. The entity has 2 columns named as "start date" and "end date". I am loading in the single combo box. 

I have two date pickers in power apps. one for "choosing start date" and other for" choosing end date". If the two dates selected the particular workweek (data from fin & ops) is loaded.

the work week is loaded like this:

      

My code for combobox:

Now my  question is I have to send the selected start workweek and end workweek to Fin & Ops. How it is possible. I want to split the selected start and end date for work week (combo box). please help me

[BCLS776]

You can add additional field(s) to the table for your combobox items, which are then accessible in the selectedItem(s):

// replace a portion of your combobox Items code with this
{
    CombinedDate: 'Start date' & "-" & 'End date',
    id: // put column name for unique record identifier here
}

After that you can use this id column from your selected item to connect back to the exact record in the PeriodTimesheetWeeks table.

Hope that helps,

Bryan

[preethi1_suresh]

Thanks for your answer. 

Now  i am changed the  Code to:

Distinct(ForAll(Filter(Sort( PeriodTimesheetWeeks,'Start date',Ascending),'Start date'>=dp_startdate.SelectedDate And 'End date'<=dp_enddate.SelectedDate),
{
CombinedDate:'Start date' &"-"&'End date',
id:'Start date',
id1:'End date'
}
),CombinedDate)

but now also it shows combobox1.selected.result only.

But what i  want is  combobox1.selected.id and combobox1.selected.id1 to send selected start and end value separately to PeriodTimesheetweeks(entity in D356).

please help me 

[BCLS776 · Accepted solution]

Ah, I see the issue - using Distinct always reduces the table down to a single column named "Result". Do you need distinct values on this column? In other words, are the time periods already unique amongst themselves? If not, then remove the Distinct() function and use the multiple-column table left behind.

Also, I recommend using something absolutely unique for the id column, such as the unique identifier for the table record itself. The start and end dates are probably not unique enough, especially if you need to use the Distinct() function.

If you must use Distinct, then you will need to use code that adds the missing id column back in like this:

With({aTable:
    ForAll(
        Filter(
            Sort(PeriodTimesheetWeeks,
                'Start date', 
                Ascending
            ),
            'Start date'>=dp_startdate.SelectedDate And 
            'End date'<=dp_enddate.SelectedDate
        ),
        {
            CombinedDate:'Start date' &"-"&'End date',
            id: // use a unique identifier field here
        }
    ),
    AddColumns(
        Distinct(aTable, CombinedDate),
        "id",
        LookUp(aTable, CombinedDate = Result, id)
    )
)

[preethi1_suresh]

Thank you so much for your answer. It helps me a lot. It works for me , but  i need 2(one for passing "start date"  and another for passing end date") id's . How can i pass 2 id's in above formula

[BCLS776]

You can put additional columns in both the ForAll() record plus the AddColumns() function to surface additional fields.

Hope that helps,

Bryan

[preethi1_suresh · Accepted solution]

Ok. thank you so much .

[preethi1_suresh]

I added to for all() but while i am adding to lookup , it shows errors

please help me .

[BCLS776 · Accepted solution]

You'll need to specifically add separate LookUp() statements and columns to the AddColumns() statement:

With({aTable:
    ForAll(
        Filter(
            Sort(PeriodTimesheetWeeks,
                'Start date', 
                Ascending
            ),
            'Start date'>=dp_startdate.SelectedDate And 
            'End date'<=dp_enddate.SelectedDate
        ),
        {
            CombinedDate:'Start date' &"-"&'End date',
            id: 'Start Date',
            idme: 'End Date'
        }
    ),
    AddColumns(
        Distinct(aTable, CombinedDate),
        "id",
        LookUp(aTable, CombinedDate = Result, id),
        "idme",
        LookUp(aTable, CombinedDate = Result, idme)
    )
)

[preethi1_suresh]

It works for me. Thank you so much for spending your valuable time . It means a lot to me 🙂