Unanswered

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

(0) Share

Report

Posted on by tomh

159

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 create item.PNG

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (2)

tomh 159 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

AlanPs1 2,471 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

tomh 159 on at

Like (0)

Report

Hey @AlanPs1 , thanks for the offer...
Tried and still getting below error. Any ideas?

Thanks!
Tom

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

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

Thanks for your help
Tom

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

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

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

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

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

@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 "
}

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like (0)

Report

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

Was this reply helpful? Yes No
tomh 159 on at

Like (0)

Report

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

Was this reply helpful? Yes No