Unanswered

Auto update Excel file from SharePoint Lists

(0) Share

Report

Posted on by shahnisarg28

Hello all,

I am trying to auto-update an Excel file from SharePoint Lists, so when an item is added, modified or deleted the Excel file would follow suit.

A couple of issues I am facing doing this.

1) I am using Filter Array and then Condition to identify if there is a new addition or any modification, however, even for any modification, Power Automate thinks it's a new addition and adds a row in Excel rather than updating any existing data, below is what I am using.

2) One of the fields in SharePoint Lists is a multiple choice, and the user can choose multiple options, I am using string function to get the data with no luck, below is what Power Automate is suggesting, but does not work.

string(triggerOutputs()?['body/DefectZone_x0028_s_x0029_'])

If anyone has any idea on how to fix this, I would appreciate any help.

TIA!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-liwei-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @shahnisarg28

1. The reason why the condition cannot identify whether the item is newly added or modified is that the parameters in the Filter array are written incorrectly.

Please try:

string(triggerOutputs()?['body/ID'])

2.You can use the method of attaching a string variable to change the value of the multi-choice column into a string.

Best Regards,

Levi

Was this reply helpful? Yes No
shahnisarg28 4 on at

Like (0)

Report
Copy link

Link copied!

Hey, First of all, thank you very much for your response.

Your suggestion worked for the multiple choice responses, however, I couldn't get it to work for updating Excel file for any modification in SharePoint Lists.

Was this reply helpful? Yes No