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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Importing Log to Datav...
Power Automate - Building Flows
Unanswered

Importing Log to Dataverse

(0) ShareShare
ReportReport
Posted on by KDR 2

Hi,

 

I'm getting a text-file like

 

Oct 17 00:44:08 Information1|Information2|Information3<CR>
Oct 17 00:44:08 Information1|Information2|Information3<CR>

....

 

which I would like to get into dataverse. I already found the trick to split it into an array using 

 
split(outputs('Compose_-_Read_in_File'), decodeUriComponent('%0D%0A'))
 

but I would like to have it like

 

Date: Oct 17 00:44:08

Variable1:Information1

Variable2:Information2

Variable3:Information3

 

But when I created this array, I did not come forward. Either I expect a string (but how to import multiple lines) or the array split did not work when I nest the logic.

 

thanks for the help

 

Categories:
Business Process Flows
I have the same question (0)
  • v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Importing Log to Dataverse

    Hi @KDR 

     

    Could you please tell me:

    Do you want to split the text into an array with newlines as delimiters?

    I have made a test for your referecne:

    1.

    vliweimsft_0-1669167659452.png

    split(outputs('Compose'),decodeUriComponent('%0A'))

    2.

    vliweimsft_1-1669167689201.png

    join(take(split(first(split(item(),'|')),' '),3),' ')

last(split(first(split(item(),'|')),' '))

split(item(),'|')[1]

replace(last(split(item(),'|')),'<CR>','')

    3.

    vliweimsft_2-1669167755951.png

    vliweimsft_3-1669167765259.png

     

     

    Best Regards,

    Levi

     

     

     

  • KDR Profile Picture
    KDR 2 on at
    Re: Importing Log to Dataverse

    Dear Levi

     

    Thanks for this really good help and content. Just for my understanding - regarding join(take(split(first(split(item(),'|')),' '),3),' ')

     

    Is the Logic starting from inner to outer? So we have

     

    Oct 17 00:44:08 Information1|Information2|Information3<CR>

     

    First  split(item(),'|' to have

     

    Oct 17 00:44:08 Information1

     

    then

    (first(....

    Does it take the Space (X) from the right of Oct 17 00:44:08X ?

    but was does 

    (split(...),3) 

    do?

    I assume it split to

    Oct

    17

    00:44:08

    And the join(...)  then put them "together" again?

     

     

     

     

     

     

     

     

     

     

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans