Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Update SharepointList out of a txt

Posted on by 28

Hi,

Im starting a project in which I will be getting a txt with all the customers in a DB

 

txt format

Customer ID, Customer Name

 

How can I build a flow that will read everyday this txt, compare to what is already in a sharepoint list, and if it finds new data, add the new rows in the shrepoint list.

 

So if the txt has lets say customer "15, TestCustomer", and that customer is not in the shrarepoint list. I would expect the flow to add it in the sharepoint list.

  • garzamalanLCG Profile Picture
    garzamalanLCG 28 on at
    Re: Update SharepointList out of a txt

    txt, comma separated ...

  • Shuvam-rpa Profile Picture
    Shuvam-rpa 889 on at
    Re: Update SharepointList out of a txt

    @garzamalanLCG what is the file type of the report??

  • garzamalanLCG Profile Picture
    garzamalanLCG 28 on at
    Re: Update SharepointList out of a txt

    not right now, but I guess I can use a sharepoint folder, if there is a solution for it.

  • Shuvam-rpa Profile Picture
    Shuvam-rpa 889 on at
    Re: Update SharepointList out of a txt

    @garzamalanLCG in sharepoint folder??

  • garzamalanLCG Profile Picture
    garzamalanLCG 28 on at
    Re: Update SharepointList out of a txt

    A report from a system, that is put in a folder everyday.

  • Shuvam-rpa Profile Picture
    Shuvam-rpa 889 on at
    Re: Update SharepointList out of a txt

    @garzamalanLCG could you tell us from where you're getting the text or from which database?

     

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

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard

Featured topics