Forum Discussion

LolaBub's avatar
LolaBub
Copper Contributor
Nov 22, 2023

Need help with multiple Nested If Columns

Hi I'm hoping someone might be able to help me with a problem.  I have an MS form using power automate to populate my SharePoint List.  I have 3 inter-dependent columns: Choice Column with 4 choic...
Lists
SharePoint Online
LolaBub's avatar
LolaBub
Copper Contributor
Nov 22, 2023

ganeshsanap 

 

Hi, the flow is triggered by 'When a new response is submitted'.  The flow itself is running and pulls every other piece of data across, except this choice column.  Yesterday when I was running some tests, I didn't have my Nested If statement in Column 3 and the flow worked fine, pulled the choice column data with no issues but the column didn't populate because I had the wrong calculation in there.  As soon as I changed the calculation to what I posted earlier, it stopped pulling the data. 

 

If I look at the flow run, it's pulling the data from the form via 'Get Response Details',:

 

but is not populating that data into 'Create Item'.  The outputs say 'null' for those fields:

Because there is branching in the form I am using 'Compose' and the following outputs within the flow to negate the flow not working when faced with a compulsory field and no data due to branching:

if(empty(outputs('Previous15')),null,outputs('Previous15')).
 
As I said, it populated yesterday but the calculated column wasn't correct so it was populating columns it shouldn't.  As soon as I change the Nested IF it stopped pulling the data but still runs successfully. 
 
 

 

LolaBub's avatar
LolaBub
Copper Contributor
Nov 22, 2023
UPDATE.
I went back to my flow and re-entered the fields and re-ran the test and the data from the choice question is now coming across so it's not the flow.

Resources