cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Syntax

Folks

            I have a form that originates on Sharepoint. It is the "new" item form. I have a text box so the default is Text(User().Fullname) . This self populates with the user name of the person filling in the information....Great. But when I select a record from the Sharepoint site for editing, it now changes that text box to the new user. Not Great. is there a way to say "if its filled in leave it, if its blank fill in with Current user"

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Syntax

Hi @Shannon_Marceau

I think you can fix this by using the following formula instead.

 

If(IsBlank(Parent.Default), 
   Text(User().Fullname), 
   Parent.Default
)

 

 

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Syntax

Hi @Shannon_Marceau

I think you can fix this by using the following formula instead.

 

If(IsBlank(Parent.Default), 
   Text(User().Fullname), 
   Parent.Default
)

 

 

View solution in original post

Highlighted

Re: Syntax

Perfect....works like a charm! Thanks

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,118)