Power Automate: Automatically updating SharePoint List through Excel Online

Question

Hi Everyone,

I'm trying to update a SharePoint List automatically from a table in an Excel Online file for a FAQ.

I am new to Power Automate, so any assistance would be greatly appreciated!

I am trying to do the following:

---

Trigger: Recurrence

(Automatically run hourly)

---

IF

Excel table is modified

---

Identify updated rows/ new row entries in Excel

---

IF row was updated in Excel

Using common identifier, update the associated entry on the SharePoint list

---

IF new row was entered in Excel

Create new entry on the SharePoint list

Thus far I have:

• Set recurrence for automatic updates
• List rows present in table (Excel Online), selected file and associated table

From here, could anyone please explain how to update the SharePoint list?

Thank you! :)

M

Answer 1

Hi M.Chowdhury：

If it is convenient for you, can you share with us the screenshots of the steps of your workflow. Also, please let us know if you receive any error messages during operation. 

Thank you for taking the time to work with us to find out what might be causing the problem.

Best regards，

Tin

Answer 2

Hi Tin,

Please find below a screenshot of the error and workflow: 

ERROR:

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Condition_2_(Note_check_the_current_item_selection)' at line '1 and column '7893' is invalid. Action 'Apply_to_each_2_-_Populate_SP_Keys_Array' must be a parent 'foreach' scope of action 'Condition_2_(Note_check_the_current_item_selection)' to be referenced by 'repeatItems' or 'items' functions.'.'.

Thank you, 

M

Answer 3

Hi

Thanks for the screenshots.

If possible, please copy and paste the screenshots of the expansion steps into the Word document. And share the document with us via this link. This helps us to help you specifically troubleshoot .

Best regards,

Tin

Answer 4

Hi M.Chowdhury：

May I know whether there are any updates to your question? If you have any questions, please feel free to contact us.

Best regards,

Tin