You’re offline. This is a read only version of the page.
Announcements
78
Hi,
I have an excel file contains three columns and it's updated automatically on daily basis
I need to upload and update a SharePoint list according to the data in this file.
The type of HinoTeam and ToyotaTeam columns on SharePoint list is Person
and the expression to pass the value from excel to each column on sharepoint is
Share
Reportitem()?['HinoTeam']
and
item()?['ToyotaTeam']
the problem I am facing is that sometimes I have null values for one of the teams.
and when the flow runs, it creates the first three items with two salespersons for the two teams, and it stops with this error when the customer is assigned to only one salesperson.
An action failed. No dependent actions succeeded.
This is a screenshot from the output of the run
Edit: On SharePoint, in the columns settings, it's not mandatory to have data in the column.
All responses (
Answers (
