Unanswered

I want my flow to record data it doesn't recognize as "Unidentified"

(0) Share

Report

Posted on by Kristupas5514

I have a flow which takes data from excel. and puts it into a SharePoint list, the excel sheet isn't very tidy, there are some blank fields and some date fields with text so I want my flow to record the data it doesn't recognize as "unidentified" in the SharePoint list.

Example:
I have this excel cell which is supposed to be a date cell but it doesn't get recognized because there is text in it, or it's blank:

My current flow:

Categories:

Building flows

I have the same question (0)

All responses (17)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @Kristupas5514

Do all dates with text contain the '_' symbol, or do they all contain the word 'data', and do they have anything in common other than the text?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kristupas5514 73 on at

Like (0)

Report

No, they don't all have the '_' symbol, honestly the only common thing is text

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Kristupas5514 ,

Does your normal date format be '2024-04-11'?

Is it only the date and does not include the time?

If so ,please try put this expression in 'Update item' and 'create item' Date parameter:

if(empty(DateOption), 'unidentify', if(greater(length(last(split(DateOption,'-'))),2), 'unidentify', DateOption))

The ‘DateOption’ in my expression represents the dynamic content of the date column.

When you quote my expression, remember to replace the ‘DateOption’ with the dynamic content of your own date column.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kristupas5514 73 on at

Like (0)

Report

It says the expression is invalid, and it doesn't let me put the required dynamic content in the expression

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @Kristupas5514 ,

Please tell me the name of your date column and I will write the expression directly to you,

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kristupas5514 73 on at

Like (0)

Report

The name of the date column is: Atleidimo data

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Kristupas5514 ,

Please try put this expression into Update item and Create item again:

if(empty(items('Apply_to_each')?['Atleidimo data'] 'unidentify', if(greater(length(last(split(items('Apply_to_each')?['Atleidimo data'],'-'))),2), 'unidentify', items('Apply_to_each')?['Atleidimo data']))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kristupas5514 73 on at

Like (0)

Report

It still says that the expression is invalid

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Kristupas5514 ,

My mistake, I wrote one less closing bracket.

if(empty(items('Apply_to_each')?['Atleidimo data']) 'unidentify', if(greater(length(last(split(items('Apply_to_each')?['Atleidimo data'],'-'))),2), 'unidentify', items('Apply_to_each')?['Atleidimo data']))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Kristupas5514 73 on at

Like (0)

Report

I don't why it still says invalid i tried checking myself if all the brackets are there and as far as i can see all of them are there, so i don't know

Was this reply helpful? Yes No