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.
aehrenwoTechnology AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
Working with Excel is easier than trying to parse a text file into e.g. an Array. Could it be it doesn't like the table name? (Working with a known file the editor should suggest the table name and column names).

I threw the following together to check and it parses the Excel into a SharePoint list without issues. The table name and column names were available in the picker.

Flow to Parse Excel into SharePoint List
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aehrenwoTechnology AnalystAuthor 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
0
Jamie McAllister MVPSharePoint ConsultantCommented:
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
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

aehrenwoTechnology AnalystAuthor 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.
0
Jamie McAllister MVPSharePoint ConsultantCommented:
I'm not an Alteryx expert, but outputting data to an Excel Table is something the community has an interest in.

Approaches seem to be appending data to an existing Excel Table, or running a Macro to add the table to the sheet, perhaps triggering that macro from Alteryx itself;

https://community.alteryx.com/t5/Data-Preparation-Blending/Updating-Excel-data-regularly-to-existing-data-files/td-p/70659

https://community.alteryx.com/t5/Setup-Configuration/How-to-Output-to-an-existing-Excel-Table-OPTIONS/td-p/43068

https://community.alteryx.com/t5/Data-Preparation-Blending/Run-Excel-Macro-after-Export-to-Create-Table/td-p/19526
0
Jamie McAllister MVPSharePoint ConsultantCommented:
Useful options suggested
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.