Create Item in SP list if Field Contains "x"- Jotform

[tomh]

Hello all, still stuck on this flow condition...need to create a condition that checks for two values in a given field. Either 'Approved' or 'Denied'. If value exists then create item in SP list. If value does not exist then do nothing. I need help writing the Expression in the "Choose a Value" field. I believe I'm doing this correctly in using the dynamic field generated "20 - App" as the field that I wil check then addin gthe qualifier "Contains" but stuck on what the Expression needs to look like.  If anyone can help with this that would be great! Lastly, I I fill no information in the "If no" part of the condition, is that the same as "do nothing"? Thanks so much all for your help on this!

Flow newbee.

Tom

[tomh]

Getting this error when using condition "contains" and value, contains('Approved','Denied')

[AlanPs1 · Accepted solution]

Hi @tomh , thank you for your post in the Flow Community.

Based on the information you have provided.

Are you looking to return true if "20 - App" has either Approved or denied in it?

If so, try this:

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[tomh · Accepted solution]

Hey @AlanPs1 , thanks for the offer...

Tried and still getting below error.  Any ideas?

Thanks!

Tom

[tomh]

I think this worked!  looks like my flow ran successfully! 

Thanks for your help

Tom

[AlanPs1]

That's great news @tomh 

Just one more thing, in order not to mis lead the future visiters.

Can you please mark my reply (message 3) as the Solution.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[tomh]

I spoke too soon... @AlanPs1

Flow is running successfully but data now not publishing to SP list. Getting condition not satisfied when the correct data is in fact now in the field. 

Thanks!

Tom

[AlanPs1]

Hi @tomh .

So the condition is returning false.

Please expand the "When a responce is submitted"  and screen shot it and post in any JSON output so I can help you try and figure out why.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[tomh]

@AlanPs1, 

below is the Json output when response is submitted:

This is the field I believe is affected: "20 - Approver: Manager #1 Approval Status": "Approved\n",

Thnaks Alan!!

{

"06 - Name:": "tom hoffman",

  "07 - Your E-mail:": "tomh@***********.com",

  "20 - Approver: Manager #1 Approval Status": "Approved\n",

  "09 - Project Description:  (Including names of vendors)": "last flow test",

  "24 - Get Page URL": "https://www.jotform.com/edit/4320981336416******",

  "05 - Project Number (CAR#):": "40\n",

  "08 - Project Name:": "last flow test",

  "10 - Est Project Cost:  (Total)": "12345",

  "12 - Budgeted:": "No\n",

  "11 - Asset Life:  (Years)": "12345",

  "13 - Location (New Locations for P1-5, P1-8, and Plant 9 Added) :": "Plant 9\n",

  "14 - Start Date:": "2019-04-26T00:00:00+00:00",

  "15 - Estimated Completion Date:": "2019-04-27T00:00:00+00:00",

  "16 - Upload Files: (Quotes, Additional Data Including ROI Analysis for Projects Over $50K)": "https://www.jotform.com/uploads/tomhoffman/91125079******/4320981336416******/bo.PNG",

  "21 - divider": "\n",

  "04 - divider31": "\n",

  "23 - Close approval": "\n",

  "19 - Approval Process Contacts": "\n",

  "22 - Reason for Denial of Request:": "adsfdsf",

  "17 - Asset Number:": "",

  "18 - Part Number:": "",

  "01 - Submission ID": "43209813364164*****",

  "02 - Form ID": "911250794******",

  "03 - Form Title": "Clone of Capital Appropriations Request "

}

[AlanPs1]

Hi @tomh 

This I would expect is the problem

"20 - Approver: Manager #1 Approval Status": "Approved\n"

within the inverted commas you have \n (new line). I suspect that this will return false so best look at the form itself.

Or if that beomes an issue, make the conditition mirror the above but best to try and understand why the form has "\n" attached to the end.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[tomh]

hey @AlanPs1 , thanks for your continued help on this...I've mirrored the "Approved\n" and "Denied\n" potential responses from the form but still getting error. Flow is running successfully but skipping the publish condition. The condition is returning 'False' but infact should be true. Please see images below.  Any ideas how tofix this?

Thanks!

Tom