Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Suggested answer

'Created By' Column not recognized suddenly in app

Posted on by 166
I have an app that has been working for over a year.  I made changes to the app a day ago and everything was working fine.  Today, I was getting errors from users that indicated there was an issue with a data source sharepoint list.  The error was seen on launch of the app and said, "The request operation is invalid.  Server Response:  List Name list faile:  Field reference is not supported."  I ran the Monitor tool which suggested an error with the operation getLookupResults on app OnStart.  I deleted the data source and then readded it.  This was successful, however, it is now throwing errors in a power automate flow that uses one of the fields in the sharepoint list.  Here is the piece of code that is giving the error:
 
'REQUESTS|EmailNotes'.Run(TextNotes_5.Text, varUserEmail, varItem.'Created By'.email, varItem.ID, varItem.Title, varUserName)
 
 
The 'Created By' column doesn't appear to be recognized.  All other columns in the sharepoint list are there.  I have refreshed the flow, and tried to add a test label to pull in the varItem.'Created By'.Email and it is not seeing this as a valid column.  All other columns in the sharepoint list are available.  Any thoughts on what may be causing this error?
 
 
  • WarrenBelz Profile Picture
    WarrenBelz 143,591 on at
    'Created By' Column not recognized suddenly in app
    Can you please note the point juniper856 has raised. When a record is stored in a Collection or Variable, the 'Created By'  column name is changed to Author, so Author.Email should work.
  • remariu Profile Picture
    remariu 166 on at
    'Created By' Column not recognized suddenly in app
    To answer both of the above responses.  The 'Created By' column is a sharepoint default column which simply identifies the user that created the item entry.  I have never made any changes to this column and the internal name is 'Created By'.  The Created column (which is the date field that is auto populated when an item is created) and all other columns in the sharepoint list are available and can be used with varItem (varItem.ID, varItem.Title, etc).  varItem is created on selection of a gallery item.  This part of the code has been used in the app for over a year.  I recently made some minor modifications to a gallery filter in another part of the app but there should have been no affect on this code as it's a completely separate section with different variables.  I'm completely baffled.
  • juniper856 Profile Picture
    juniper856 4 on at
    'Created By' Column not recognized suddenly in app
    When storing a SharePoint item in a variable sometime it stores the internal name instead of the label. Does Author.Email work instead of 'Created By'.Email? You should be able to see if there's any difference in the Global Variables menu.
  • Suggested answer
    cha_cha Profile Picture
    cha_cha 4,797 on at
    'Created By' Column not recognized suddenly in app
    Hello
     
    First trace first what is the value of your varItem.
     
    Usually as values gets passed around the app, spaces gets removed.
     
    You can check it via this menu:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard