web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Created a form with ca...
Power Apps
Answered

Created a form with cascading dropdown. Saves no problem to Sharepoint, but are blank when opening the entry through the form.

(0) ShareShare
ReportReport
Posted on by 359

Hi. I built a PowerApps simple form connected to a Sharepoint list with cascading dropdown function. When entering info into the app, it records no problem to my sharepoint list. when i open the entry back up in powerapps, the entries are blank (even though they are saved in Sharepoint).

Screen Shot 2022-02-28 at 3.59.18 PM.png
Categories:
  • WarrenBelz Profile Picture
    156,738 Most Valuable Professional on at

    Hi @cchan000 ,

    What are the Items of the Combo Box and the DefaultSelectedItems. Also what type of field are you writing back to, and what are the names of this field and the Combo Box?

  • cchan000 Profile Picture
    359 on at

    Hi! They are dropdown boxes. I have a couple so I'll list them. Here is what the contents are. they don't have a defaultselecteditems. Default dropdown says "1".

     

    i have attached a few more screenshots that may help.

     

    for MARKET

    ITEMS = Sort(Distinct(WCC_Info,Title),Result)

     

    for DMA

    ITEMS = Filter(WCC_Info, DMA = dd_dma_1.Selected.Result)

     

     

    Screen Shot 2022-02-28 at 4.18.08 PM.png
    Screen Shot 2022-02-28 at 4.22.54 PM.png
  • WarrenBelz Profile Picture
    156,738 Most Valuable Professional on at

    @cchan000 ,

    I was assuming combo boxes - what is the Default of both of these and also the Update on both Data Cards. Could you also give me the names of the controls (I see one is dd_Market_1) and the names and types of fields you are writing back to (as asked previously).

  • cchan000 Profile Picture
    359 on at

    Thanks for getting back to me.

     

    Market (control name = dd_market_1)
    default = "1"

    Update (on the card) = dd_market_1.Selected.Result

    writing to sharepoint field Market and type is Single Line of text

     

    DMA (control name = dd_dma_1)

    default = "1"

    Update (on the card) = dd_dma_1.Selected.Result

    writing to sharepoint field DMA type is Single Line of Text

  • Verified answer
    WarrenBelz Profile Picture
    156,738 Most Valuable Professional on at

    Hi @cchan000 ,

    Your issue on both is the Default 

    dd_market_1 should be 

    ThisItem.Market

    dd_dma_1 should be

    ThisItem.DMA

     

    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.

    Visit my blog Practical Power Apps

     

  • cchan000 Profile Picture
    359 on at

    brilliant thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 320

#3
Mohsin Ali Profile Picture

Mohsin Ali 246

Last 30 days Overall leaderboard