update csv files on SharePoint

(1) Share

Report

Posted on by shirokun

Hello!

thank you @rzaneti for helping with my question on Uploading multiple CSV files to SharePoint

I have a follow up question: I want to update the files that were uploaded because now the status has changed.

The condition is

1) if the file uploaded is new then upload the new data to sharepoint list

2) if the file uploaded is an old data but with new updates then update the new information to sharepoint list

Here is the flow:

this is the error message I got

Here is the new data

How can I fix my flow?

Thank you for your help!!!

Categories:

Building flows

I have the same question (0)

All responses (29)

Answers (0)

Sort by

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @shirokun

I see no errors

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
shirokun on at

Like (1)

Report
Copy link

Link copied!

Hi @FLMike but with the same Machine ID, the status doesn't get updated =(
the status are in "choice" format. for example, after the upload line 1 should be changed from New to Pending.

Was this reply helpful? Yes No
Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

i definitely want to help but I dont see the code or the error so I am not sure what to solve.

What does but with the same Machine Id the status isn't updated, I don't know what you were trying to do, or how you were trying to do it, and what failed, so I can say how to fix it 🙂

Please provide more details and the error itself 🙂

Was this reply helpful? Yes No
shirokun on at

Like (1)

Report
Copy link

Link copied!

I uploaded multiple csv files to sharepoint library which will upload the information to sharepoint list. Now some of the CSV files maybe repeated with updated information so i want to create a condition:
True- Run the new file and upload the new Machine ID (first line) to sharepoint list
False- update the information for existing Machine ID (first line)

My flow for update item doesnt work. the condition should go to false in this case because all the I uploaded a file with same machine ID just with different status.
Thank you!

Was this reply helpful? Yes No
Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @shirokun

Thanks but you still aren't showing me error. That's what I need to see, not a picture of the run as it doesn't show me the error.

I need the actual text of the error.

If some how my eyes are brain are missing it please hehe point me to it.

Thanks!

Was this reply helpful? Yes No
shirokun on at

Like (1)

Report
Copy link

Link copied!

would these help? Thank you

Was this reply helpful? Yes No
rzaneti 4,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @shirokun ,

Can you please share an image of the "body" property from the raw outputs of your "Get items" action? Based on the shared images, it looks like your "Get items" is returning as empty.

You can find the raw outputs by selection your action, navigating until the "Outputs" action, and then clicking in "Show raw outputs":

For additional instructions on how to access the raw outputs, refer to this article.

Was this reply helpful? Yes No
shirokun on at

Like (1)

Report
Copy link

Link copied!

Thank you! Here it is, what does this mean

Was this reply helpful? Yes No
rzaneti 4,483 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @shirokun ,

You received an authorization error. I recommend you to double check if the user connection used for Get items action has access to the SharePoint Site List from where you are reading the items.

You can find the current user connection by clicking in the Get items action in the flow edit page, in the same pane where you enter data about the List to be read. The current user is highlighted in yellow, and if you need to modify the user connection, you can achieve it by clicking in Change connection (highlighted in green):

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
shirokun on at

Like (1)

Report
Copy link

Link copied!

Thank you.. i m not too sure whats wrong because it is connecting to the correct account.
could you show me what would be the best way to build "update csv file" on top of what I have already created?

Thank you.

Was this reply helpful? Yes No