Answered

Choose a column depending on the Header

(0) Share

Report

Posted on by RC6

Hi everyone,

I am building an app in which I record some data from users inputs and depending on the chosen option in a dropdown list, I want to use that value to indicate the column name I am going to enter some data later. I've tried some other solutions and none of them worked. This is the last one I've tried, using a global variable but when I try to call it later it gets some error.

//Block in which, depending what data is saved if there is a previous order with the same Contract.
Set(Variable,Ddwn_device.SelectedText.Value);
If(
 //Condition for modifying an existing record
Not(IsBlank(LookUp(Registry,Contract=contract.Text))),Patch(Registry,LookUp(Registry,Contract=contract.Text),{Total_Quantity:LookUp(Registry,Contract=contract.Text,Total_Quantity)+Value(quantity.Text)},{Value(Variable):Value(quantity.Text)}),
 //Condition for creating a new record
Patch(Registry,Defaults(Registry),{Contract:contract.Text},{Date:Text(Date.SelectedDate)},{Customer:customer.Text},{Country:Ddwn_country.SelectedText.Value},{Requested_Date:Text(RequestedDate.SelectedDate)},{Condition:Ddwn_condition.SelectedText.Value},{Total_Quantity:quantity.Text}))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RC6 ,

Column names should be static in your case. So, using variable is not an option. To accomplish your need, you can use a Switch function:

//Block in which, depending what data is saved if there is a previous order with the same Contract. Set(Variable,Ddwn_device.Selected.Value); If( //Condition for modifying an existing record Not(IsBlank(LookUp(Registry,Contract=contract.Text))),Patch(Registry,LookUp(Registry,Contract=contract.Text),{Total_Quantity:LookUp(Registry,Contract=contract.Text,Total_Quantity)+Value(quantity.Text)},Switch(Variable, "Value1",{Value1:Value(quantity.Text)}, "Value2",{Value2:Value(quantity.Text)}, "Value3",{Value3:Value(quantity.Text)}, "Value4",{Value4:Value(quantity.Text)}, ...), //Condition for creating a new record Patch(Registry,Defaults(Registry),{Contract:contract.Text},{Date:Text(Date.SelectedDate)},{Customer:customer.Text},{Country:Ddwn_country.Selected.Value},{Requested_Date:Text(RequestedDate.SelectedDate)},{Condition:Ddwn_condition.Selected.Value},{Total_Quantity:quantity.Text}))

Best regards,

Was this reply helpful? Yes No
RC6 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, sorry for the late answer, but I was really busy and kept this app aside for a while.
Look, I've tried what you suggested here but didn't work. I got rid of the variable and used instead of a 'Switch' lots of nested conditionals (If) and it worked perfectly. The thing is that in the end I am always checking the same text input and the only thing that changes is the value. Due to this, I keep on with the 'switch' statement but it never works.
Nonetheless, it's clear that there must be some error with the way I am using the statement. So I'll keep on trying different options with 'switch' and if it doesn't work I'll go with the nested 'If' statements.
Thanks so much.

Was this reply helpful? Yes No