How do I tell Automate not to create a new item in Sharepoint if Forms box is blank?

[BeaufortWizard]

How do I tell Automate not to create a new item in Sharepoint if the Forms box is blank?

So i tell automate to create a new item and then select which box to pull the info from, trouble is I have 15 boxes for customers to report defects and if you fill out one and rest blank all 15 boxes will create a new item?? i only want an item created if the defects box is filled in  what do i need to tell it to do in each create item box (condition is equal to null? )

[Ankesh_49]

@BeaufortWizard  Try below:

 or you can get the form response detail in compose and use @empty(outputs('Compose')) in condition.

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[BeaufortWizard]

Thank you, will I have to do 15 conditions & 15 create items ? 

[Ankesh_49]

which defects box in the form you want to check? or is it like if anyone out of 15 boxes is filled?

[BeaufortWizard]

If any of the 15 boxes are filled I need it to create a new item into my Microsoft List as a new snag from each box filled. If any of those boxes arent filled i don't want an item created. 

[Ankesh_49]

use multiple or conditions within the same condition control, like below and if any of the condition satisfies then create item:

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[BeaufortWizard]

Hi, unfortunately, it is still pulling through boxes that are blank and creating a new item 

Do I filled in one and left other blank 

[Ankesh_49]

Uncheck the checkboxes

[BeaufortWizard]

still pulls through blank box / not sure why so frsutrating 

[Hardesh15]

@Ankesh_49  Sorry Ankesh i am responding to this thread. 

@BeaufortWizard  Why are you using multiple create item actions?. This is the reason it is creating multiple rows.

Use one create item action in Yes block.

Pass all defects dynamic content one by one in your description column. Like Defect 1 Defect 2 etc.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[Ankesh_49]

@Hardesh15  No worries. Intention is to get it resolved. Also, single thread can have multiple solution providers😀😀😀

Also, I recommended to use only one create item in the screenshot above.

@BeaufortWizard Please check if it solves your purpose, you use only one create item action as we are are checking multiple conditions in our condition control.

Hope it helps!!

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[BeaufortWizard]

@Hardesh15 Hi, so power automate hasnt pulled through all my questions in forms. So I'm having to create item and then put in relevant defect 1, defect 2 etc 

[BeaufortWizard]

@Hardesh15 im trying to get my list to separate defect issues which is why I've had to create multiple boxes on my MS Forms so clients can register multiple defects per form rather than one form each which a clinet just wont do, unfortunately. 

Where is says defect 1 and then item underneath is blank... that's because defect 2 was left blank, but i dont want it to create the item. 

Have I structured my form wrong? or can i get power automate to ignore blank boxes. 

[Hardesh15]

@BeaufortWizard Pls Share Complete flow screens because i am seeing apply to each loop in your screens.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[Ankesh_49]

@BeaufortWizard What is the process you are trying to automate 

[BeaufortWizard]

@Hardesh15 @Ankesh_49 

So currently, my company manually input defects into Excel reported by house buyers from the new homes we've built them. The house buyers report these via e-mail currently. 

I created a MS Form for the house buyer to fill in with their details & there are 15 boxes to raise seperate defects issues. Reason is because we have multiple rooms within a house and each room usually has several defects but i need them logged separately so i can report on defects like type / how long took to repair / performance of our sub-contractors etc 

The form them populates into my issue tracker within Microsoft Lists via Power Automate

[BeaufortWizard]

@Hardesh15 @Ankesh_49 Is there anything I can put into the code? 

[BeaufortWizard]

@Hardesh15 @Ankesh_49 have you found a solution as yet? 

[Ankesh_49]

@BeaufortWizard   How would you like the flow to behave, if there are 5 defects for a single property?

You want 5 items created in SharePoint list or You want 1 item with 5 defects listed in defects description column?

Could you please help me with this so, that next steps can be suggested. Either we change the form or we should handle it in power automate flow.

In case you want to connect, DM Me.

Thanks
Ankesh

[BeaufortWizard]

HI 

I will DM you