Answered

Need to create online connection powerapps with txt.file

(0) Share

Report

Posted on by Community Power Pla...

Please, could you advise on one topic:

I have txt. file, regularily extracted from ERP. I need to create a connection, which will take the latest data to powerapps form.

Which way of connection is most efficient.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

eka24 20,923 on at

Like (0)

Report

I suggest you convert it to excel, store it in Excel Table. You can then import it to the Powerapps or create a collection in Powerapps.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

There is around 20 th lines in the file, while excel recognises only 2000.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

I don't get your point. Are you saying you cannot use 20 lines or rows to create Excel Table?
If that's the case, you can even create Excel Table with one or blank row.

If you are talking about limitations on 2000, import of Excel could be up to 15000 rows.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I mean 20 000 rows

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,
You need to bring it into a SharePoint list - please have a read of this article.

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi, WarrenBelz

Thanks for advise. I will do a small flow to update Sharepoint form Excel, and connnect Sharepoint with my forms

Thanks a lot!

Was this reply helpful? Yes No