cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chamblm
Level: Power Up

IF function in Microsoft Flow

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?

4 REPLIES 4
Mike8
Level 10

Re: IF function in Microsoft Flow

Hello,

Can you try this?
if(equals(triggerBody()?['Line_x0020_Manager'], 'Lynn_Kearney'),concat(triggerBody()?['First_x0020_Name'],' ',triggerBody()?['Last_x0020_Name']), 'null')

Chamblm
Level: Power Up

Re: IF function in Microsoft Flow

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) 

 

Capture.PNG

 

Mike8
Level 10

Re: IF function in Microsoft Flow

Hello,

Does the BBTA New Starter Form list have First Name and Last Name as column names?
If it doesn't, I can see why it returns an error.
If it does, I don't know Smiley Happy

Administrator
Administrator

Re: IF function in Microsoft Flow

Thanks for your help @Mike8 - @Chamblm can you let me know if you're still experiencing an issue with this?

 

@TopShelf-MSFT

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 53 members 4,367 guests
Please welcome our newest community members: