cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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

Highlighted

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
Highlighted
Resolver I
Resolver I

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

 

error.PNG

Highlighted
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

Highlighted

Hey @AlanPs1 , thanks for the offer...

Tried and still getting below error.  Any ideas?

 

Thanks!

Tom


error.PNG

View solution in original post

Highlighted

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

 

Thanks for your help

Tom

Highlighted
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!


Highlighted

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

Highlighted
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!


Highlighted

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


Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (6,628)