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
ganeshsanap's avatar
ganeshsanap
MVP

LolaBub 

 

So, is the issue with Power automate flow not pulling the data from MS form response and not adding it in SharePoint list columns? If yes, can you share details about the flow you are using?

 

Or is there any issue/error with the calculated columns?

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

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