Unanswered

Flow fails when title column is alphanumeric, how to use condition for alphanumeric column

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a flow which runs good, unless Title column is not alpha numeric.

But Title column is mostly like a unique ID generated in excel ,so i need it combination of text and numbers to make it unique.

Issue is flow runs when that title is just text based that is "ABC", but when it comes in as "ABC123" it fails.

can Anybody help me to move forward with this validation part.

My flow My flow flow 14.JPG Excel list with alpha numeric column to be added in listerror in run1 flow 3.JPG 42Condition passes text based cell values not alphanumeric

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

There shouldn't be any issue with it being an alphanumeric column. I do see an error saying that you have a value expecting a date - STARTDATE - that isn't correct. But, are you saying that it works fully in other cases? Since these 2 alphanumerics are at the bottom of the list in Excel, it could be that the dates are not formatted as dates, whereas the others are. It could be a lot of things - let's start with that and then work our way through.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

hI @Rhiassuring ,
It worked now, thank you very much.
Still not sure wat was the issue, i just edited the date value again.
BTW, thank you !

Was this reply helpful? Yes No