Maps data from sharepoint list to dataverse table

 

1. Prepare sharepoint array

- Get items from sharepoint list, remember to setup the theshold, since default item limit is 100.

- In Select operation(Select 2), in Map section,select needed columns, including Key column, which is linked 2 sources.

 

2. Create list row action for dataverse table, select needed columns, including: key column(crff2_lot_seq) and GUID columns (crff2_t_lot_detail1id).

 

3. Add operation Compose, select Input is key Key column from previous step. The Appy to each action with Output field will be automatic created.

 

4. Add operation Filter array including:

From: Select output from step 1 (Select 2)

In the first criteria field, type Item() in the Expression

Condition: “ Is equal to” then select Output from previous step (Compose)

 

5. Add operation Condition, in criteria field, input length(body('Filter_array')) is greater than 0

 

6. Add operation Update a row for both result, select table name, row ID=GUID column, input needed result.