Create a survey like app with a target value

[BenD20022]

Hello together,

I am new here and i sadly have a tight deadline for this project so i would really appreciate any support on this matter. I would like to create a small app for my company. I have created a table in which I have calculated a target value (Customer Lifetime Value). I would like to query the different attributes of the table one after the other with several windows and then get a target value at the end based on their results. So I don't have to calculate a new formula here, it's more like a search but more nicely presented.
I think that shouldn't be too difficult or do you have any ideas on how I can implement this?

I would be very happy if you have ideas for me here. Many thanks for your help

[v-jefferni]

Hi @BenD20022 ,

Could you please share more details about your scenario? What do you mean by "query the different attributes of the table one after the other with several windows and then get a target value at the end based on their results"? Would you like users to add new entries to the table or just search an entry in the table based on some conditions and get the final result from a specific column?

Best regards,

[BenD20022]

Hey @v-jefferni,

thank you for your fast response.

The topic for which I want to create the app is customer lifetime value. This is a value that is calculated from revenue and costs. I have calculated this with different attributes in an Excel in the last column. Now I want to build a mobile application that allows users to enter the different attributes one after the other like in a survey. An example would be: Question 1: What gender is the person? Then 2/3 answer options would be listed from which one can be choosen. Question 2: Which product did the customer buy? Then different answer options should be displayed again, such as: Product 1, Product 2 and so on. Once all the attributes have been answerd, a value for the customer lifetime value should appear on the last page. I don't need another formula for this, because this is already created in Excel.
I think this should not be too complicated technically because the programme only has to search for the values column by column and then find the row at the end that has all the values that were entered and display the corresponding result of the last column.

I really appreciate your help.

Best regrads,

Ben

[v-jefferni]

Hi @BenD20022 ,

You are absolutely correct on this process. All you need to do is using a LookUp function to get a specific record from the Excel table and displaying the result from the last column, i.e., in a Label. I assume that you are using Dropdowns for users to select an answer, then the formula in Text of the Label could be as follows:

LookUp(YourTable, Column1 = Q1Answer.Selected.Value && Column2 = Q2Answer.Selected.Value && Column3 = Q3Answer.Selected.Value && ..., TheLastColumn)

Best regards,

[BenD20022]

Hi @v-jefferni,

thanks again for your really fast response. I already looked up such drop down menus in excel but i want to make this a little bit nicer with such an App. Or do you mean to insert the function in the app? And if so how can i do this? how can i link the answers to the formula or how can i track the answers for the formula to take those and look up the value. I think the app would be really great as the colleagues are not required to have the whole excel on hand. Can you give me some more details on how to build this as i am new here and never created something like this. I think this would be a really impressive solution for my colleagues if we can make this work. 

Best regards, 

Ben

[v-jefferni · Accepted solution]

Hi @BenD20022 ,

All I mentioned in previous post are controls in the App. You can add Labels and Dropdowns on different Screens, use Labels to display Questions and Dropdowns to provide choices for users to select. On the last screen, you can also use a Label with its Text set to the formula I provided.

Understand tables and records in canvas apps - Power Apps | Microsoft Learn

Best regards,