cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

loading values from sp list to a text with allowed values

Hi,

 

I have a sp list containing two fields:

One of the text field is named as 'Site name', I edited the field to 'allowed values' so that changes into a drop down field. 

 

See screenshot below, I added expression below for the items property but its not working. I want to load values from site title field from Site request list as you see in the expression, site title is a text field only.

Capture.JPG

Capture.JPG

 

getting warning below 

Untitled.png

thoughts on the fix?

3 REPLIES 3
Super User III
Super User III

Hi @dmistry ,

A Text field does not have Choices - you need

Filter(
   SiteRequest_l
    'Site Title' <> Blank()
).'Site Title'

 

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.

Hi @dmistry ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Community Support
Community Support

Hi@dmistry,

Based on the issue that you mentioned, do you want to fill the Dropdown with the site title value?

Could you please share a bit more about the scenario?

I assume that you want to load values from the site title to the site name, right?

Based on both of the site title and site name are Text type, here is a formula you can refer to.

 

Filter(SiteRequest_l,!(IsBlank('Site Title'))).'Site Title'

 

33.png

Hope it could help.

Best Regards,

Qi

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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