Answered

Convert text to record

(0) Share

Report

Posted on by Yuna-Evita

Hello everyone,

I have a power apps application connected to a Microsoft List, this list contains collones choices with a city name as title.

In my application I have a listBox with the names of these cities, a dropdownbox with the available choices and a gallery.

I want to filter my list according to the selected city and the selected choice but I don't know how to convert ListBox1.Selected into records to get the value and compare it with dropdownbox.SelectedText.Value:

Exemple for Adrian city:

SortByColumns(Filter([@TestEmilien], Adrian.Value=Dropdown1.SelectedText.Value), "Title", If(SortDescending1, Descending, Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this:

SortByColumns(Filter([@TestEmilien], Adrian.Value=Dropdown1.Selected.Value), "Title", If(SortDescending1, Descending, Ascending))

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Was this reply helpful? Yes No
Yuna-Evita 41 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Nogueira,

Sorry but did you change somethings ?
Adrian is a city I take for example, it's a column name, I need to put somethings like ListBox1.Selected (but that return me text and I need record)

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If you have only th "City"?

Like this:

SortByColumns(Filter([@TestEmilien], City =Dropdown1.SelectedText.Value), "Title", If(SortDescending1, Descending, Ascending))

You can also try this:
SortByColumns(Filter([@TestEmilien], Text(City) =Dropdown1.SelectedText.Value), "Title", If(SortDescending1, Descending, Ascending))

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Was this reply helpful? Yes No
Yuna-Evita 41 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't need to convert"City" in text, it's a text and I need to convert in record.
In my list a city correspond to a column and in my applications I have a listbox with the name of each cities.
I want to take the selected item from my listbox convert it into record (column from my list) and compare the value with my dropdown to filter them

Was this reply helpful? Yes No
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-convert-a-Text-Type-to-Record-Type/td-p/777391

https://powerusers.microsoft.com/t5/Building-Power-Apps/Convert-Text-to-Record/td-p/487169

This might solve your problem..

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

Was this reply helpful? Yes No