update csv files on SharePoint

[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!!! 

[FLMike]

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

[shirokun]

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. 

[FLMike]

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 🙂

[shirokun]

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!

[FLMike]

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!

[shirokun]

would these help? Thank you

[rzaneti]

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.

[shirokun]

Thank you! Here it is, what does this mean 

[rzaneti]

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/ 

[shirokun]

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. 

[rzaneti]

Hi @shirokun ,

You are in the right path and your flow design seems correct. Before the "Authorization error", I was suspecting that maybe you were receiving empty arrays from your Get items.

Are you receiving this same "Authorization error" for other runs from this same flow?

[shirokun]

I rebuilt the flow and the authentication part is solved!! thank you

could you confirm what condition parameters should it be?

if i do 

length(outputs('Get_items')?['body/value']) is equal to 0 then it goes to True create item

length(outputs('Get_items')?['body/value']) is greater than 0 then it goes to False and update items BUT the flow didnt work because "not specified

what should i put under ID? in update item?

i feel like im getting closer!! thank you so much!!!

[rzaneti]

Hi @shirokun ,

I'm happy to hear that the Authorization problem is solved! 

The conditions to test the Get items length is correct. For the Update Item action ID property, it looks like you must use the expression items('Apply_to_each')?['ID']. If it doesn't work for you, please share an image of your Apply to each input.

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/ 

[shirokun]

I am sorry, it still doesnt work =(

The flow doesnt seem to recognize that it needs to be "updated." When i tested the flow, it went to create the file again. it doesnt recognize the file already exist and needs to update the new information. where did i do wrong here? 

this is an image of  my apply to each input 

If i force the flow to update, it still says the update item is not specified ☹️

 Thank you for continue to help me!

[rzaneti]

Hi @shirokun ,

Don't need to be sorry; we are here to help 🙂

Some questions for:

1. When you tested the flow, did it create a new item, or did it just not update SP List?

2. In your first post, the Update Item action is stored inside a loop called For each. I know that you recreated the flow after that. In this second version of the flow, is the loop name still For each? If yes, I gave you the incorrect expression for the "ID" reference in Update Item in the last message: it actually should be items('For_each')?['ID']. 

It looks like we are close to a solution here!

[shirokun]

Hi 😃

1. When I tested the flow, it created a new item despite the items already being on the SharePoint list.

2. if i change 

length(outputs('Get_items')?['body/value']) to greater than 0 then it goes to update by default then 

I have a question: On my list, every item has a unqiue "Machine ID." What can I do so the flow can recognize the Machine ID and, if it's the same, perform an update instead of creating a new item? I wonder if its because I am missing a step at "Get item?" I manually typed in Title eq "Machine ID." should i have used Dynamic content for "Machine ID" for its not an option when i look it up.  

Thank you for helping once again. 

[rzaneti]

Hi @shirokun ,

As an item was created, we can conclude that the length was always equal to zero. You can keep it as equal to zero, rather greater than zero, because the problem is happening on your Get items.

I see that you were using the Title eq 'Req ID' (then changed to Title eq 'Machine ID'), which seems to be the problem. When you use the filter query, you are filtering the values from a column for the value passed after the eq. So in your case, you are returning only the List items which Title is equal to 'Req ID' or 'Machine ID' as strings (and not as dynamic contents).

Your conclusion is correct: use a dynamic content must solve this problem. To test if it makes sense, I recommend you to change the filter query to something like [machine ID logical name] eq 1440351, and see if the flow works. You must change the text in red for the actual logical name of your Machine ID column, and the text in green for any actual Machine ID value (I took an example from your Excel image, shared in your first post in this thread).

If you don't know how to get the column logical name, check this thread that I recently answered about it: https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-Filter-Query-for-Column-with-Spaces/m-p... 

Also, I'm sharing an article that I recently wrote about how to work with Filter query in Power Automate, which can be helpful for your case: http://digitalmill.net/2024/06/21/working-with-filter-query-in-power-automate/ 

At this moment, please make this test with a "hardcoded" Machine ID. If it works, we can then move forward in accessing its value dynamically 🙂

[shirokun]

Thank you! these articles are helpful.

When I changed to MachineID eq '5555555' it worked =). so how do I move forward from here if "Machine ID" is not one of my dynamic function values?

Also,  my instruction is to update the status and comments, for example, from status "new" to "pending". The flow went successful, but the status didn't change and the new comment didnt get added.  

i think my get items is also missing something is in this case then?  

=( 

thank you again

[rzaneti]

Hi @shirokun ,

I'm happy that it worked with the hardcoded MachineID!

Now you need to:

• Replace the 5555555 in your Get items Filter query by the dynamic content of your MachineID from Filter array action. If you don't see a dynamic content for this property, try to use the expression item()['MachineID'] or item()['Machine_ID']. If it also doesn't work, please share the raw outputs from Filter array.
• A similar approach will be taken for the Comments. Right now you are just passing as input the same value that you captured from Get items, so you are reassigning the current value to the column. To solve it, set the dynamic content of the comments from Filter array as input for Update item action. If you don't find it, use this expression: item()['Comments']
• Finally, for the Status column, we will need you to share the raw outputs from Get items.