Forms to Sharepoint with Column conditions

Silver Contributor

Jun 08, 2020

timparsons the way I do this sort of thing is as follows and doesn't involve arrays. I have 2 lists, the main one for the orders and a second one that holds the unit cost for each item that might be ordered:

Following is the form:

The flow is then below. The trigger is When a new response is submitted and the first action is Get response details.

Next, add a SharePoint Get items gets the items from the UnitCost list:

Next add an Apply to each control and select value from the Get items section of the dynamic content. Next, add a Condition and in the left box select Title from the Get items section of the dynamic content is equal to then select Item from the Get response details section of the dynamic content.

Even though you would have asked for the quantity in your form, Forms nevertheless saves it as text. So add a Compose and add the following expression (in the Expression tab of the dynamic content box):

int(body('Get_response_details')?['r4a70bd783b204c608871dd004c360add'])

you won't need to add the ID for the quantity question, just select it from the dynamic content tab and it will add the relevant question id.

Add another Compose and add the UnitCost column from the Get items section of the dynamic content box.

I always like Compose controls so add another one for the total cost where the expression will be a multiplication of the 2 previous Compose controls, i.e. UnitCost * Quantity:

mul(outputs('ComposeUnitCost'),outputs('ComposeQuantity'))

Finally we add the SharePoint Create item action and add in the outputs from the Compose controls and the other relevant fields.

As you can see, the number ordered, their unit cost and the total cost are added into the SharePoint list:

Hope that helps.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Forum Discussion

Forms to Sharepoint with Column conditions