Hi,
I have a sharepoint lsit with 10 columns, Some of these are Drop Down Lists, as i wanted to control the data entry if they enter it via sharepoint. I have created a powerapp, and i am trying to build a graph, but in my collection it will not allow me to select the data from the column that has the datatype of Drop down List. It requires only text, numeric, date.
How can i create a collection from my sharepoint list, that will allow me to use the data from any of the fields, regardless of data type. is there a way to cast the data as text in the collection?

Report
All responses (
Answers (