Based on drop-down choice, show specific row of a table / or get data from specific cells of table.

(0) Share

Report

Posted on by Magistralis

Good day beautiful people,

I have created table within my PowerApp Form which looks like this:

Country name	Group email	Personal email 1	Personal email 2
Germany	group@company.com	personal1@company.com	personal2@company.com
Austria	lorem@company.com	ipsum@company.com	lorem.ipsum@company.com

and so on, in total this table will be adjusted based on SP input (so far 30 countries).

I also have a drop-down field in my main form, where users pick one of "Country name" values. Based on their pick, I need:

1. If picked Germany, I would like to receive whole row from a table which contains Germany in Country name (but without Germany itself, just Group email, Personal email1, Personal email2)

2. I can create 3 different text fields where each of Group email, Personal email1 and Personal email2.

Depends on what is easier I can live with option 1 or 2.

End result

I won't show the results of pick from drop-down directly in form. I will use PowerAutomate to create an email where I can reference those fields / field but 1st I need to fill them up in PowerApps.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (2)

Report

I would do the second option.

So, 3 labels and 1 combobox.
In first label write:

LookUp( YourDataSoure, 'Country Name' = Combobox1.Selected.Value).'Group email'

In second label write:

LookUp( YourDataSoure, 'Country Name' = Combobox1.Selected.Value).'Personal email 1'

In third label write:

LookUp( YourDataSoure, 'Country Name' = Combobox1.Selected.Value).'Personal email 2'

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

My website!

Was this reply helpful? Yes No
Magistralis 75 on at

Like (0)

Report

Thank you for your answer, unfortunately I'm doing something wrong.

I'm not sure why I can't setup the combo box to work. I have tried google some stuff around it but the solutions provided there is not working either. Can you please assist me on this one as well?

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

Like (0)

Report

Sure...

Was this reply helpful? Yes No
Magistralis 75 on at

Like (0)

Report

When I try use this formula for a label:

LookUp( YourDataSource, 'Country Name' = Combobox1.Selected.Value).'Group email'

It pops out a message that it was expecting an operator *, + etc. So I have modified it to:

LookUp( YourDataSource, 'Country Name' = Combobox1.Selected.Value,'Group email')

And now it says that Record and Text cannot be compared.

My latest formula looks like this:
LookUp('SharePoint List Name', 'Country list' = ComboBox7.Selected.Value.)'Group email'

I would like to learn what I am doing wrong.

P.S. Combobox has been fixed and now shows values from a table column "Country list".

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

Like (0)

Report

Instead of .Value might be another Field...

As you can see, it is working

Was this reply helpful? Yes No
Magistralis 75 on at

Like (0)

Report

I do believe that your solution is correct but I cannot repopulate it. I will try to use it with different approach to see which combination will work me.
For now my max result is error notification that I'm comparing two different data types. I believe that I need to change value type within ComboBox since the result is marked as a table (correct me if I'm wrong).
My ComboBox got this formula:
Choices('Link to SP with Country Name table'.Country_list)

Below I will present how my fields does looks like, maybe this will ring a bell for someone:
Legend:
SharePoint_2 > SharePoint where I have manually created a table with Country Name and emails from 1st post.
Country name renamed to Country_list
Group email renamed to IT_Group_email

ComboBox (works)
Choices('SharePoint2'.Country_list)

Label field (error: can't compare two different data types (Record and table)
LookUp('SharePoint_2',Country_list=ComboBox1.SelectedItems).IT_Group_Email

I have also tried using Gallery like here Filter, Search, and LookUp functions in Power Apps (contains video) - Power Apps | Microsoft Docs but failed miserably as well.

Was this reply helpful? Yes No
Verified answer

Magistralis 75 on at

Like (0)

Report

Solved with LookUp SharePoint column.
In nutshell:
1. Created country list on main sharepoint.
2. Created country list, email columns on secondary sharepoint.
3. Created LookUp columns on main sharepoints and then hide them.
4. Created dropdown list within PowerApps where user can pick a country.
5. Added item (Group email Lookup, Personal1 Lookup, Personal2 Lookup column) to the PowerAutomate email template.

Was this reply helpful? Yes No