We help IT Professionals succeed at work.

MS Flow.. parse a text file

760 Views
Last Modified: 2018-05-04
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.
Comment
Watch Question

Cloud Expert
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Adam EhrenworthLead Technology Analyst

Author

Commented:
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 McAllisterCloud Expert
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2014

Commented:
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
Adam EhrenworthLead Technology Analyst

Author

Commented:
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.
Jamie McAllisterCloud Expert
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Jamie McAllisterCloud Expert
CERTIFIED EXPERT
Most Valuable Expert 2013
Top Expert 2014

Commented:
Useful options suggested
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.