If formula in a Sharepoint list

Copper Contributor

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 :)

0 Replies