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)
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand