cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tomh
Resolver I
Resolver I

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

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.

 

Tomcreate item.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
AlanPs1
Resident Rockstar
Resident Rockstar

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:Capture-509.png

 

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

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


View solution in original post

Hey @AlanPs1 , thanks for the offer...

Tried and still getting below error.  Any ideas?

 

Thanks!

Tom


error.PNG

View solution in original post

10 REPLIES 10
tomh
Resolver I
Resolver I

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

 

error.PNG

AlanPs1
Resident Rockstar
Resident Rockstar

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:Capture-509.png

 

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

 

Any other questions, just ask.

 

Thanks, Alan

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Hey @AlanPs1 , thanks for the offer...

Tried and still getting below error.  Any ideas?

 

Thanks!

Tom


error.PNG

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

 

Thanks for your help

Tom

AlanPs1
Resident Rockstar
Resident Rockstar

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


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

still error.PNG

AlanPs1
Resident Rockstar
Resident Rockstar

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


@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",
  "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
Resident Rockstar
Resident Rockstar

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

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


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

success.PNG

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,990)