Forum Discussion
If formula in a Sharepoint list
Hello everyone,
I hope everything is fine on your side! I thank you in advance for the time you spend on my problem.
I am developing an application through PowerApp from a SharePoint list. In my SP list, I have columns where the user will be able to select an option through several choices.
On the interface, the user will have to choose items from 4 questions that are dependent on the previous choice. So I would like to know, if there was a way that I could create a formula (probably IF) that will allow to indicate that when the user chooses option a in question 1, in question 2 he will be able to choose options (1,2,3) and so on...
Basically: Q1 : (a,b,c), Q2 : =if((q1=a; 1,2,3); si(q1=b;4,5,6); si(q1=c;7,8,9))
Because every time I try something it gives me an error message and I'm brought to the home page
Thanks to all 🙂