Hello, I'm hoping someone can understand why my app is doing this. I've created simple three question app and it's getting very close to being done, but this problem is stumping me.
I am able to successful write to my Sharepoint list with this code:
Patch('QuestionDB', {Title: Now(), Employee: User().FullName, Question1: If(A1N, true), Question2: If(A2N, true), Question3: If(A3N, true)});
When I view the list, my columns Question1, Question2, and Question three I see values of either true or false, so it is clear the data is being written correctly. But when I attempt to display it in my app, the columns only display solid check marks, no matter if the list value is true or false.
Here is sliver of the Sharepoint list:
Here is what the app looks like:
The Question1, 2, and 3 variables are the last three columns and should show a True or False in the data table columns. It being d data table instead of a gallery seems to be wrong too. Not sure how I didn't get a gallery. What did I do wrong?
TIA,
Aaron
Solved! Go to Solution.
I reloaded the data from my Sharepoint list and it updated the data types. So that solved my data table issues, but I decided to switch to a gallery instead of a data table. It's working out much nicer.
Please try changing your column to a Text Column as shown in the screenshot below. Do this by clicking on the Data Table then Edit fields.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
It doesn't appear that I have those choices for the Question fields.
I reloaded the data from my Sharepoint list and it updated the data types. So that solved my data table issues, but I decided to switch to a gallery instead of a data table. It's working out much nicer.
Agreed, I always use Galleries: never Data Tables. The Gallery control offers so much flexibility it makes Data Tables useless IMHO 😞
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."