Load different excel sheet.

(0) Share

Report

Posted on by RL-26071304-0

126

Hello.

I have an excel file with 3 sheets: SEP_AREA, SEP_PROJECT_A and SEP_PROJECT_B.

SEP_AREA: Area1, Area2 and Area3.

SEP_PROJECT_A: Project1, Project2, Project3, Project4, Project5.

SEP_PROJECT_B: Project6, Project7, Project8, Project9, Project10.

On PowerApps, my Dropdown1 has the values from SEP_AREA.

I would like to do something like:

If value from Dropdown1= "Area1" load SEP_PROJECT_A else SEP_PROJECT_B.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RLeite :

Could you please show me the data structure of these three tables? What are Area1/2/3 and Project1/2/3? Are they column names Or just value?

What does 'load' mean? Do you want to show SEP_PROJECT_A or SEP_PROJECT_B in a gallery?

Best Regards,

Bof

Was this reply helpful? Yes No
RL-26071304-0 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi.

Sheet: SEP_AREA
Table: TABLE_AREA
Values: Area1, Area2, Area3.

Sheet: SEP_PROJECT_A
Table: TABLE_PROJECT_A
Values: Project1, Project2, Project3, Project4, Project5.

Sheet: SEP_PROJECT_A
Table: TABLE_PROJECT_A
Values: Project6, Project7, Project8, Project9, Project10.

I have a Dropdown with the values from TABLE_AREA.
The result should be values from TABLE_PROJECT_A or TABLE_PROJECT_B in another Dropdown.

Example:
Dropdown1: "Area1"
Dropdown2: "Project1", "Project2", "Project3", "Project4", "Project5".

Example 2:
Dropdown1: "Area2"
Dropdown2: "Project6", "Project7", "Project8", "Project9", "Project10".

I hope you can understand.
Thank you.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RLeite :

If TABLE_PROJECT_A and TABLE_PROJECT_B have the same data structure (same column names and same data type),please try:

Switch( Dropdown1.SelectedText.Value, "Value1", TABLE_PROJECT_A, "Value2", TABLE_PROJECT_B )

Best Regards,

Bof

Was this reply helpful? Yes No