web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I want my flow to reco...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 73

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:

Kristupas5514_0-1712830831790.png


My current flow:

Kristupas5514_1-1712832232591.png

Kristupas5514_2-1712832277784.png

Kristupas5514_4-1712832353847.png

 

 

Categories:
I have the same question (0)
  • v-yetonggu-msft Profile Picture
    on at

    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?

    vyetonggumsft_0-1712835415653.png

    Best Regards,

    Sunshine Gu

  • Kristupas5514 Profile Picture
    73 on at

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

  • v-yetonggu-msft Profile Picture
    on at

    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

  • Kristupas5514 Profile Picture
    73 on at

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

    Kristupas5514_0-1713160043697.pngKristupas5514_1-1713160087783.png

     

  • v-yetonggu-msft Profile Picture
    on at

    Hi @Kristupas5514 ,

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

    Best Regards,

    Sunshine Gu

  • Kristupas5514 Profile Picture
    73 on at

    The name of the date column is: Atleidimo data

  • v-yetonggu-msft Profile Picture
    on at

    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

  • Kristupas5514 Profile Picture
    73 on at

    It still says that the expression is invalid

  • v-yetonggu-msft Profile Picture
    on at

    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

  • Kristupas5514 Profile Picture
    73 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard