cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

If !isBlank & IsBlank Unexpected characters...

Hello, 

I'm receiving the Unexpected characters. The formula contains 'ParenClose' where 'Comma' is expected and need assistance on how to sort the error message. 

On a Select button moving from one Edit Screen to the following Edit Screen, I have the If function to check on 2 conditions before moving to the next screen. Checking / testing one at a time works but combining the 2 is my issue where I receive the error message. 

 

Please assist with how do I combine the two I checks before being able to move to the next Edit Screen. Thank you. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @Mareliese 

Could you try this to see if it works? I think there might have been an extra comma.

If(
   !IsBlank(LookUp(JobCardMetering,
                 "ID_Column" = DataCardValue_JobCardNo.Text
                 )
         ) &&
   IsBlank(LookUp(JobCardMetering,
                "Employee" = DataCardValue4_Employee.Text 
                )
),
SubmitForm(EditForm1_Intro),
Notify(
"The saem Job Card has been submitted. A new Job Card no. was generated. Please check.",
NotificationType.Error
)
);
Refresh(JobCardMetering)

 

View solution in original post

9 REPLIES 9
Highlighted
Super User III
Super User III

Hi @Mareliese 

Could you try this to see if it works? I think there might have been an extra comma.

If(
   !IsBlank(LookUp(JobCardMetering,
                 "ID_Column" = DataCardValue_JobCardNo.Text
                 )
         ) &&
   IsBlank(LookUp(JobCardMetering,
                "Employee" = DataCardValue4_Employee.Text 
                )
),
SubmitForm(EditForm1_Intro),
Notify(
"The saem Job Card has been submitted. A new Job Card no. was generated. Please check.",
NotificationType.Error
)
);
Refresh(JobCardMetering)

 

View solution in original post

Highlighted
Super User III
Super User III

Remove the double quotes on the ID_COLUMN and Employee 

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Super User III
Super User III

@Mareliese 

I suspect that eka24 is correct in that you need to remove the double quotes.

If(
   !IsBlank(LookUp(JobCardMetering,
                 ID_Column = DataCardValue_JobCardNo.Text
                 )
         ) &&
   IsBlank(LookUp(JobCardMetering,
                Employee = DataCardValue4_Employee.Text 
                )
),
SubmitForm(EditForm1_Intro),
Notify(
"The saem Job Card has been submitted. A new Job Card no. was generated. Please check.",
NotificationType.Error
)
);
Refresh(JobCardMetering)

The reason I didn't mention this is because you said that Checking / testing one at a time works.

Can you confirm that's really the case? Is it actually returning the correct data with the double quotes?

Highlighted

Thank you timl,

Your formula is working. But I still cannot see the extra comma comparing yours to mine 😀.

But thank you. It is working 😀.  I probably need a different pair of eyes. 

Thanks

Mareliese 

Highlighted

Thank you eka24. 

It works without having to remove the double quotes. 

My column names is in the double quotes. 

What is the difference between double quotes and no quotes?

Please let me know. 

Thank you

Mareliese 

Highlighted

Correct timl, 

It was and is working with the column names in the double quotes. 

Your formula with removing comma, which I cannot see 😁, fixed the problem. 

Thanks

Mareliese 

Highlighted

Double quotes is used for Text like "abcd"

Whiles single quotes is used to wrap column names  or Table Names with spaces

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

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted

Mareliese - glad that fixed the problem for you!

For these types of issues, I find that stepping through each line and indenting the code can often help identify where there's a missing character.

Good luck with the rest of your app!

Highlighted

Thank you eka24. 

I've changed the the column names to single quotes, and all is working. 

(I'm wondering why in this case it did not make a difference?!)

Thank you

Mareliese 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (13,124)