Forum Discussion

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

MVP

Nov 22, 2023

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

Copper Contributor

Nov 22, 2023

ganeshsanap

Hi, thank you for responding earlier but I've fixed it. My IF(ISBLANK statement was incorrect. I've changed it to this and it works perfectly:

=IF(ISBLANK([Requested Days (1 of 1)]),"", DATE(YEAR([Submission Date]), MONTH([Submission Date]), DAY([Submission Date])+ ([Requested Days (1 of 1)])))

Thanks again.