Hi,
I have been advised to use Sharepoint and stay away from Excel but this is my first app project, and I am quite far in already. Appreciate it if you can cut me some slack.
On a canvas,
1) I have a global variable, HG, whose value is dependent upon some selection that the user has made earlier. Here, it is 4:
2) Basically, I have some dropdown boxes and a "Next" Button to look up some values from an Excel sheet. It is like below:
3) On the "Next" button above, I am trying to look up values in an Excel table. The selections in the dropbox are also from an Excel table. The code goes something like this:
ClearCollect(QA1A,HG&Q1DDBox.Selected.RS);
ClearCollect(QA1B,AddColumns(QA1A, "QnNo", 1, "RF", LookUp(Q1Table,CONRS=HG&Q1DDBox.Selected.RS,RF)));
ClearCollect(QAScr1,RenameColumns(QA1B,"Value","RS"));
4)In the collection, QAScr1, the RS is correct but the RF is wrong:
5) The Q1Table is as below:
RV CONRS RS HG RF
| Q1Concat | 125% or less | 25% or less | 1 | 1 |
| Q1Concat | 126% to 50% | 26% to 50% | 1 | 0.75 |
| Q1Concat | 151% to 75% | 51% to 75% | 1 | 0.5 |
| Q1Concat | 1More than 75% | More than 75% | 1 | 0.25 |
| Q1Concat | 225% or less | 25% or less | 2 | 1.6 |
| Q1Concat | 226% to 50% | 26% to 50% | 2 | 1 |
| Q1Concat | 251% to 75% | 51% to 75% | 2 | 5.5 |
| Q1Concat | 2More than 75% | More than 75% | 2 | 2.3 |
| Q1Concat | 425% or less | 25% or less | 4 | 2 |
| Q1Concat | 426% to 50% | 26% to 50% | 4 | 1.5 |
| Q1Concat | 451% to 75% | 51% to 75% | 4 | 1 |
| Q1Concat | 4More than 75% | More than 75% | 4 | 0.5 |
The look up problem remains for other dropboxes further down the app. Based on the pt 5, RF should have been 1 instead of 0.5. For some reason, the code is looking for the case where HG=1 & the dropbox.Selected.RS instead of HG=4 & the dropbox.Selected.RS.
Any ideas?
Thank you.
