Unanswered

Column does not exist

(0) Share

Report

Posted on by Mudpie555

I am at a loss on how to fix the above error. The column 'Author' does not even exist in my Share Point List? What am I missing here?

Here is the formula that is creating the error above.

Patch(TaskCollection, ThisItem, {Location: inputloc.Text, Task: inputtask.Text, Minutes: inputmin.Text, Notes: inputnote.Text}); Collect(TaskCollection, {Location: "", Task: "", Minutes: "", Notes: ""})

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Author is the Created By system column in a SharePoint list. If you created your collection directly from a list that may be where the Author column is coming from.

Was this reply helpful? Yes No
Mudpie555 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the quick reply. I am very new to Power Apps. My question is why would that column matter if its not a column I am using in my list? And how do I fix this?

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Given the code you are using it looks like you are patching a collection. If you created the collection by just copying a SharePoint list then it probably exported that column as well and Created By is a system column which means it is required. Is TaskCollection the name of your list or a Collection you are creating from a SharePoint list?

Was this reply helpful? Yes No
Mudpie555 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It’s a collection I am trying to make from my sharepoint list.

Was this reply helpful? Yes No
Pstork1 69,599 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Then make sure you use ShowColumns() to select just the columns you want in the collection when you are creating it from the SharePoint list. Otherwise you will end up with the system columns as well, which are required.

Was this reply helpful? Yes No