'Created By' Column not recognized suddenly in app

(1) Share

Report

Posted on by remariu

173

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?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

cha_cha 4,932 Moderator on at

Like (0)

Report

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:

Was this reply helpful? Yes No
juniper856 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
remariu 173 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No