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

Choices Column Error Not accepting Table value

 

Hello all, 

 

I hope you are doing well. I have inserted a Sharepoint List as a Table in PowerApps but it seems that the Choices Columns are not accepted by Powerapp as it is giving an error Table Value are not accepted , and scope formula is not supported. 

 

I would really appreciate your help on how two solve this issue. Please see below screen shot. 

 

Thank you fro your help. 

 

Screen Shot 2020-06-06 at 3.51.33 PM.png

8 REPLIES 8
Highlighted
Super User
Super User

Re: Choices Column Error Not accepting Table value

In the Text put;

ThisItem.Connectivity.Value

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper III
Helper III

Re: Choices Column Error Not accepting Table value

Hi @eka24 , 

 

Thank you for your response actually I tried value unfortunately it didn't work. 

 

Instead I used the below formula and it did. Do you think it is suitable ? 

 

Screen Shot 2020-06-06 at 4.50.52 PM.png

Highlighted
Super User
Super User

Re: Choices Column Error Not accepting Table value

Can you show a screenshot of the ITEMS of the Gallery not the label.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Highlighted
Helper III
Helper III

Re: Choices Column Error Not accepting Table value

Hi @eka24 , 

 

I think it does not like when multiple selection are enabled. 

 

Screen Shot 2020-06-06 at 5.05.03 PM.png

Screen Shot 2020-06-06 at 5.07.53 PM.png

 
Highlighted
Super User
Super User

Re: Choices Column Error Not accepting Table value

The picture below shows the Items of a Gallery:

Kindly do same and show the items of the Gallery:

Gallery items.JPG

 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Helper III
Helper III

Re: Choices Column Error Not accepting Table value

Hello @eka24 , 

 

No worries I managed to add it as a gallery and not as a table. 

 

However, I may ask you another question related , my Sharepoint list has Column of pictures that are stored in the Assets Library and associated to each Item. 

 

However, wonen I create a PowerApps galery the item column shows as a hyperlink and not the picture. I tried to add it via the media gallery but it doesn't work since each item has a different icon and the gallery replicate the same item to the whole list. 

 

if you have any recommendation that would be lovely. 

 

Thank you, 

 

Najwa. 

 

Screen Shot 2020-06-06 at 11.55.31 PM.png

Highlighted
Helper III
Helper III

Re: Choices Column Error Not accepting Table value

Hello @eka24 , 

 

I tried with Gallery unfortunately it doesn't work 

 

Screen Shot 2020-06-07 at 1.48.21 PM.png

Highlighted
Community Support
Community Support

Re: Choices Column Error Not accepting Table value

Hi @Najwa_Rahal ,

 

Try to add an image control in the Gallery, and set the image property to ThisItem.Icon, then the pictures will be displayed in the gallery.

Sik

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response 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 (5,734)