Share
Report
78Hi,
I have an excel file contains three columns and it's updated automatically on daily basis
- AccountName: the name of customer
- HinoTeam: the salesperson from Hino Team assigned to this account
- ToyotaTeam: the salesperson from Toyota Team assigned to this account
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
item()?['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 (
