Power Platform Community Forum Thread Details

Hi Folks,

I'm probably missing something really simple here but I'm stuck with a flow that I've built to add/update data from an Excel workbook to a SPO List.

What is my flow meant to do?

I've built a little MS Teams Owner training module and the participants complete an assessment using a MS Forms Quiz. The results of this quiz are saved in an Excel workbook table and my Flow is built to move some data from this table into a SPO List, this is done on a 30 minute schedule:

Here are the three columns that I want to move from the Excel table:

This is the target SPO list, the Person and Email fields are getting populated successfully, but the Member and Score fields get overwritten with blank data

Here are the relevant excerpts from my flow:

The Get items action filter query matches the Email column in the list with the Email column in the excel workbook

The Condition action looks for SPO list items not equal to 0 characters

The update item action brings the excel workbook content into the relevant SPO list fields.

The flow reports that it runs successfully every 30 minutes and it is correctly matching on the Email address, however it doesn't update the Member and Score fields successfully. Also noting that if it doesn't match on email (the "false" action above) it correctly adds all of these same workbook fields, including Member and Score to the SPO list.

Categories:

General topics