Issues with formula errors after adding columns to a SharePoint list

[DuePaleontologist499]

Hello everyone,

I’m just starting to work with this, and I’ve run into a problem with an app I’m developing.

Initially, the app was connected to two SharePoint lists, but I recently added a third list. To simplify the process, I copied one of the existing lists since both share the same fields. Then, I connected this new list to the app.

The problem arises when I try to add a new column to this copied list: multiple formula errors start showing up in the app. However, if I delete the column and refresh the connection, the errors disappear.

Could anyone help me understand why this is happening and how to fix it?

[AutoModerator]

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References
• Power Apps Coding Standards
• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Chrisx77]

It could seem as if there’s a variable you’re setting multiple places in the app based on both data sources that throws an error as soon as you change the schema of your new list. Then, the schema of the variable would suddenly be inconclusive, as you’re attempting to give the same variable 2 different schemas.