Hi !
I have a Power App that at the very end, it prints four columns. I am requested to add a fifth column. So in the interface, under PrintScreen, under DailyQCGallery, I add a text label and I call it CommentsLabel. I added code (well I basically copied code that was from the fourth column) into this CommentsLabel. And I only changed one thing in the code. It is at the very end where the particular needed SharePoint column is listed (that I need to pull the value from). I just substituted the name of the SharePoint column - which is Comment, into the code. But Power Apps doesn't like this. It gives this error message: Invalid argument type. Cannot use unknown values in this context. The '.' operator cannot be used on text values.
So since the formula in the 4th column works - I was trying to see what would be a difference. The 4th column gets a value from the SP list column that is a Choice. My fifth column
pulls from the SP Comment column which is multiple lines of text (also that Comment column uses enhanced rich text - not sure that rich text is needed here, but it is what it is).
I tried to copy that Comment column and its values to a new column, so I can mess and do stuff with this copied column that I can always undo. I made this new column a calculated column - and chose the Comment column to get its values from. When I did that - a new screen just pops up and just says "error" and the screen I was working in disappears.
Anyway - how can I correct the code to pull into the label, the values in thatare in the SharePoint List column (Comment)? Or can this even be done? Below is the code.
If(Month(DateAdd(_firstDayOfMonth,ThisItem.Value, TimeUnit.Days))= MonthSelected,LookUp(QCArray, 'QC Type'.Value = "Daily" And DateNumber = ((Year(DateAdd(_firstDayOfMonth,ThisItem.Value, TimeUnit.Days))*10000)+(Month(DateAdd(_firstDayOfMonth,ThisItem.Value, TimeUnit.Days))*100)+(Day(DateAdd(_firstDayOfMonth,ThisItem.Value, TimeUnit.Days))))).Comment.Value)
