Switch data in forms for user selection

(0) Share

Report

Posted on by YC-24070300-0

Hello all,

Here I meet a problem.

I insert the form in power apps and connect to the excel online raw data.

For a column named size, I hope the user can select between A3, A4, B4, B5, 8K, 16K and so on. But in my raw data, I only have sheet width and sheet length.

I have use the distinct function in items, that is,

Distinct(Filter(Table2Data,Description=DataCardValue3.Selected.Value && 'GSM '=DataCardValue4.Selected.Value),'Sheet width')

After applying the function above, the user can select between 297, 210,195 and so on.

So what I need is to switch 297, 210, 195 to A3, A4, 16K...

I tried to use the function in onselect, that is,

Switch(DataCardValue5.Selected.Value,
"297","A3",
"210","A4",
"420","A3",
"182","B5",
"195","16K",
"257","B4",
"270","8K",
"216","Letter Size")

But it seems not work.

Hope you can help me solve the problem.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Yiqian ,

Your current Switch returns a text, you should put it on control which is used to show paper size.

If you are using drop down for paper size, please try this.

Items of Dropdown.

["A3","A4","B5","16K","B4","8K","Letter Size"]

Default of Dropdown.

Switch(DataCardValue5.Selected.Value, "297","A3", "210","A4", "420","A3", "182","B5", "195","16K", "257","B4", "270","8K", "216","Letter Size")

Best regards,

Rimmon

Was this reply helpful? Yes No
YC-24070300-0 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Thanks for your reply.
But I still have one more question that where should I put this function in this dropdown list?
Distinct(Filter(Table2Data,Description=DataCardValue3.Selected.Value && 'GSM '=DataCardValue4.Selected.Value),'Sheet width')

Since I need to filter size first to make the choice more accurate, this may be somewhat difficult.

Thanks!

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

Like (0)

Report
Copy link

Link copied!

Hi @Yiqian ,

Do you want to make the drop-down options more accurate?

If so, it should be in Items property.

Best regards,

Rimmon

Was this reply helpful? Yes No