Avatar of Adam Ehrenworth
Adam EhrenworthFlag for United States of America asked on

MS Flow.. parse a text file

anyone know there's a way to parse text file using MS Flow? I'm trying to populate a SharePoint list using Excel but I can't get it to recognize it as a table so I'm hoping maybe I can use a flat file instead.
Microsoft SharePoint

Avatar of undefined
Last Comment
Jamie McAllister

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jamie McAllister

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Adam Ehrenworth

Jamie,

The issue I am running into is that the Excel file that is created is being produced by another tool and it is doesn't have a "table" associated with it. I can only see if that table if I go into Excel and create it manually. This is not helpful if I want to fully automate this process each day.

That is why I asked about the text file option. OR is there a way to force a table into an excel file with Flow if the number of rows might vary each time the new file is created by this other tool and stored on SharePoint Online?

Thanks for your help.

Adam
Jamie McAllister

Hi Adam,

I'm pushing the conversation back to Excel as there aren't nice options trying to parse a file. Data to CSV is fine but not the other way.

What tool is creating the errant Excel? Is it really an Excel file or a CSV?

J
ASKER
Adam Ehrenworth

Alteryx Designer runs each day and pulls HR data from a source DB into an Excel file (I tried using it to push to SP directly but it is VERY slow).  

Anyway, I can only get the flow to recognize the columns in the file if I open it up and create the table manually.

Hopefully, I am missing an easy step here as being able to automate the push from Excel to the SharePoint List would be a big win.

Again - thanks for any insight.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
SOLUTION
Jamie McAllister

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jamie McAllister

Useful options suggested