Answered

Combobox with two columns where one is datetime

(0) Share

Report

Posted on by Gyllentid

894

Searching I found a few solutions to displaying a date in Combobox. I have tried them and they work but now I need to display a second column in the combobox drop down. I try to add something to the the second column and it defaults to one.

Solutions I have found for displaying dates:

ForAll(TableName,
{
DateValue:ColumnNameA,
DateDisplay:Text(ColumnNameA, "dd mmm yy")
}
)

Distinct(TableName,Text(ColumnNameA,"[$-en-US]dd/mm/yyyy")).Result

I managed to add the filter I needed to second option:

Distinct(
Filter(
Attendance_Course,
ColumnLookup.LookupName in colectionA.columnNameX,
IsBlank('ColumnNameB')
),
Text(
ColumnNameA,
"[$-en-US]dd/mm/yyyy"
)
).Result

Should I add another distinct or what can I do to display two columns where one is a datetime field?

Thanks kindly

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Gyllentid 894 on at

Like (0)

Report
Copy link

Link copied!

Nothing there. Nothing shows up if I add ["Result","ColumnNameC"] in Displayfields property.

Was this reply helpful? Yes No
Verified answer

Gyllentid 894 on at

Like (0)

Report
Copy link

Link copied!

I think this might work:

ForAll(TableName,
{
DateValue:ColumnNameA,
DateDisplay:Text(ColumnNameA, "dd mmm yy"),
Attendance:ColumnNameB
}
)

If its helpful for anyone else:

I added the filter inside the forall, on the outside it did not work:

ForAll(Filter(TableName,LookupColumn.LookUpName in collectionA.columnnameX,
IsBlank('ColumnNameC')
),
{
DateValue:ColumnNameA,
DateDisplay:Text(ColumnNameA, "dd mmm yy"),
Attendance:ColumnNameB
}
)

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @shavora ,

Thanks for sharing. Please consider marking your solution as 'Solution' to get more people to notice this post.

Best Regards,

Bof

Was this reply helpful? Yes No
Gyllentid 894 on at

Like (0)

Report
Copy link

Link copied!

I can also share how to store the id of a Dataverse row in this so it can be accessible for a patch in a button:

ForAll(TableName,
{
DateValue:ColumnNameA,
DateDisplay:Text(ColumnNameA, "dd mmm yy"),
Attendance:ColumnNameB

ID:ThisRecord.TableName
}
)

But I ended up using this in a small gallery instead of a combobox:

Was this reply helpful? Yes No