PowerApps Form: the property expects record values but this rule produces incompatible table values

[tested1]

Hello!

I have a sharepoint form that I made in powerapps.

There are many columns with 'Choice' fields/options for users to select answers. 

I created a new master list for each of these choice columns and put all the fields in there, so like a Masterlist 

I then used a look up column to get these values for the official form.

I had to change some of these options and now my form gives the error: the property expects record values but this rule produces incompatible table values. Now all the columns I have changed give this error under 'Default'

Is there a way to automatically update my PowerApps form if I delete say a Choice in a SharePoint list column? or make changes. It would be great if I could click say update and the Powerapps form is updated.

Please see pics. Thank you!

[v-xida-msft]

Hi @tested1 ,

Could you please share a bit more about your scenario?

Could you please share a bit more about the Divisions_x0020__x0026__x0020_Fu column in your SP list?

Further, what changes do you made to these columns which faces this issue?

The error message that you mentioned seems to tell that the Default property of the Divisions_x0020__x0026__x0020_Fu column is required to provided a Reocrd value, but the ThisItem.Divisions... formula returns a Table value.

Please consider take a try to re-create an app based on your SP list, then check if the issue is solved.

Note: If you custom a form for your SP list using PowerApps, please consider remove the custom form, then re-add a new custom form for your SP list, check if the issue is solved.

Best regards,

[tested1]

Hi @v-xida-msft 

All I done was delete the divisions list in the look up column and remade it with some different values. 

What other details would you like for the divisions column? I will put a screenshot of the look up column. I have 2 lists one main one and then another with the divisions values. The first list looks up the choices in list 2 (divisions)

But I just removed and re-added the divisions column to fix it

However I lost all of my formatting - colours etc I done to the division column and had to redo it..

If I need to change a value in say the divisions look up column again (Which I most likely will need to if things are outdated), what should I do to the PowerApps form? Do I need to remove and readd the column/datacard every time?? 

Thank you

[R3dKap]

Hi @tested1,

If I understand well, what you did is that:

• in your list you had choices columns like this:
  • scChoice1, with the following choice values:
    • Choice1Value1
    • Choice1Value2
    • ...

And then you decided you wanted lookups instead of choices... right ?

So you created lists to put your choices values (what you call your master lists):

• myListForOldChoice1, with the following items:
  • Choice1Value1
  • Choice1Value2
  • ...

Then, I guess you created new columns in your list to replace your old choices:

• scLookup1, attached to list myListForOldChoice1

If this is what you did, then you have to remove your old choice fields from your form in PowerApps and replace them with your new lookup columns. And everything should be fine...

Of course, in the list items, you will loose all data that was previously entered in the old choices columns...

Is this of any help to you ?

Emmanuel

[tested1 · Accepted solution]

hi @R3dKap 

How do I remove my old choices in powerapps form or update my column to my newest ones in my look up list on Power Apps form?

Yeah that sounds right.. I just created 1 master list which contained the choices then used a look up in the main form to get these choices to try to stay organised because we will probably have to keep changing some

EDIT: 

Nevermind I just refreshed the form and the choices etc look to have been updated automatically.