cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Transform table data as text data

Hi Power Apps community,

 

I am building a simple app that returns data from SharePoint list. The data is in a Gallery that when an item is selected, more information about that item is shown. However, I have 2 columns in SharePoint list that the data is structured as data. So when I try to return the data from these tow columns I receive the following error: "Expect Text value". 

 

I have tried many workarounds but no success.

 

Does anyone know how to fix this?

Any help will be much appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper IV
Helper IV

Re: Transform table data as text data

Hi @WarrenBelz thanks for your help and reply. 

 

The App is working now fine. I have change the TextInput, that needed to return the data, and I have used a List Box. Now the data is showing.

 

Thanks again for your help.

 

View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

Re: Transform table data as text data

Hi @JB0007 ,

When you say structured as data, what type of data? If a choice or lookup field, it is FieldName.Value

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Highlighted
Helper IV
Helper IV

Re: Transform table data as text data

Hi @WarrenBelz  thanks for the reply.

 

I meant the data is structured as Table. 

Highlighted
Super User III
Super User III

Re: Transform table data as text data

@JB0007 ,

What sort of table and what are you trying to write to it?

Highlighted
Helper IV
Helper IV

Re: Transform table data as text data

Hi @WarrenBelz ,

 

Actually I didn't create the list myself, but I assume the column in SharePoint is created using a Check Box function in the list itself. So you can select the choices direct in SharePoint. However, I need to create a a version of that in Power Apps. I don't need to write anything back in list. But if a use a Label or TextInput and set its Text/ Default to e.x. Gallery1.Selected.Documents, it returns an error "Expect Text Value". 

Highlighted
Super User III
Super User III

Re: Transform table data as text data

Hi @JB0007 ,

Please send me a screenshot of your field definition in SharePoint and highlight the field you are trying to write to.

Highlighted
Helper IV
Helper IV

Re: Transform table data as text data

Hi @WarrenBelz thanks for your help and reply. 

 

The App is working now fine. I have change the TextInput, that needed to return the data, and I have used a List Box. Now the data is showing.

 

Thanks again for your help.

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,443)