So we have an online form set up that exports data to a SharePoint list. We want to enter this information into several spreadsheets automatically, so we don't have to go in and make changes to all of them whenever the form is submitted
In the attached image, I've tried to create a formula whereby the person's name appears under their line manager's column in a table, but the "expression is incorrect".
The formula used is as below:
if(equals(triggerBody()?['Line_x0020_Manager'], 'Lynn_Kearney'),'triggerBody()?['First_x0020_Name']triggerBody()?['Last_x0020_Name']', 'null'))
Does anybody know why this might be invalid, or how to get it working?
Awesome, thanks, that seems to at least get the formula working
When testing running the flow, it fails because it cannot find First/Last name in the table
I'd have thought it would be "update a row" to add to an existing table (see below)