Skip to main content

Notifications

Community site session details
Power Apps - Building Power Apps
Answered

Editable Grid PowerApps Combo Problem

Like (0) ShareShare
ReportReport
Posted on 22 Oct 2022 19:19:23 by 173

HI,

I had made the editable gallery as like you but I followed Reza Durrani video
https://www.youtube.com/watch?v=wI6SHGQ9ATg

But I am unable to patch few combo box in SP list as that column is a single line text in sp and in powerapps its a combo box which have items coming from Dynamics table.

I am unable to write a patch statement for this column.

Gallery:

MustH_0-1666465948490.png

 



EMBDEC Combo

Items:                                 
 ReleaseProdcuts (Dynamics Table) , Items (Value):  'Item Number'
DefaultSelectedItems: 
         Table({Result: ThisItem.EMBDecorID}) (its shows as Table)

I am not able to patch the selected 'item number' in SP in a single text field  

MustH_1-1666466276383.png

 


@eka24  @RandyHayes  @StalinPonnusamy 

Please help!!!

  • WarrenBelz Profile Picture
    146,743 Most Valuable Professional on 24 Oct 2022 at 11:06:18
    Re: Editable Grid PowerApps Combo Problem

    @MustH ,

    Based on the values you have posted, if the Patch of

    EMBDecorID: EMBDecCombo.Selected.'Item number'

    is correct (which you have confirmed) AND

    EMBRecordID is a Single Line of Text column in SharePoint AND

    EMBDecCombo is a single selection then the DefaultSelectedItems would be

    {'Item No': ThisItem.EMBDecorID}

    as I have posted earlier.

  • Verified answer
    WarrenBelz Profile Picture
    146,743 Most Valuable Professional on 24 Oct 2022 at 07:10:30
    Re: Editable Grid PowerApps Combo Problem

    @MustH ,

    I certainly hope so - that is the correct syntax for a single select combo box DefaultSelectedItems if it is reading from a Text field.

     

     

  • MustafaHussain Profile Picture
    173 on 24 Oct 2022 at 06:38:53
    Re: Editable Grid PowerApps Combo Problem

    @WarrenBelz 

    Well, there is one Problem, I think you are mistaken in understanding.

    Well, I have a ComboBox in an Editable Gallery,
    and the Items (DataSource) of the ComboBox is from the Dynamics Table ( ReleaseProducts).
    and the Fields (Value) of the ComboBox from right properties I have chosen ( ItemNumber) which is the column of Dynamics Table. 

    Now, for The DefaultSelectedItems  , I wanted to set it to the SharePoint List Text Column which is EMBDecorID 

    as ThisItem.EMBDecorID

    But it says, Expected Table Value 

    How, can I set it defaults with respect to the text column of SharePoint?

  • MustafaHussain Profile Picture
    173 on 24 Oct 2022 at 06:27:50
    Re: Editable Grid PowerApps Combo Problem

    Hi @WarrenBelz 

    MustH_0-1666592913649.png

     


    The DefaultSelectedItems  is showing as a record, will it be correct? when I load the gallery in View Mode? will it load the text from my Text Column into this Combo?

  • WarrenBelz Profile Picture
    146,743 Most Valuable Professional on 24 Oct 2022 at 06:08:25
    Re: Editable Grid PowerApps Combo Problem

    @MustH 

    As I posted earlier

    {'Item No': ThisItem.EMBDecorID}

     

    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

  • MustafaHussain Profile Picture
    173 on 24 Oct 2022 at 05:09:46
    Re: Editable Grid PowerApps Combo Problem

    Hi @WarrenBelz  THis Fixed the issue in Patch statement,

    I have used 

    Patch( //Saving Data to SharePoint From Collection
     ColGridData,
     ThisItem,
     {
     SaleOrderLineSequence: SaleOrderLineSeq.Text,
     EMBDecorID: EMBDecCombo.Selected.'Item number',
     DecorationType: DecorTypeCombo.Selected,
     NumOfLogos: Value(NumberOfLogosInput.Text),
     StitchCount: StitchCountInput.Text
    }
    )

      But, What should be in the DefaultSelectedItems ?

    MustH_0-1666588145822.png

     

    It gives error when I use ( ThisItem.EMBDecorID) 
    as my ComboBox values are from different DataSource.

    What Should I set in DefaultSelectedItems in View Mode when the Gallery (Grid) is in View Mode?

  • WarrenBelz Profile Picture
    146,743 Most Valuable Professional on 23 Oct 2022 at 20:31:37
    Re: Editable Grid PowerApps Combo Problem

    @MustH ,

    All you need is the output of the Combo Box (if it is a single selection) as this will be a Text value able to be written back to the Text field. I was guessing Result based on your posted code assuming it was a Distinct filter or Split() statement. It appears it is probably

    EMBDecorID: EMBDecCombo.Selected.'Item No'

    If you type in EMBDecCombo.Selected. (note second dot), the valid values will come up underneath.
    I am also wondering why you have used Table() in the DefaultSelectedItems and have referred to Result here (based on the Items you have now posted). If the field displayed is 'Item No', it should just be

    {'Item No': ThisItem.EMBDecorID}

     

    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

  • MustafaHussain Profile Picture
    173 on 23 Oct 2022 at 12:28:11
    Re: Editable Grid PowerApps Combo Problem

    @WarrenBelz  
    sorry, for late reply

    Well,  EMBDecorID is a single line text column in my sharepoint list. 

    and it's a Single Select Combo

    I am using Editable Gallery and I have inserted a ComboBox  as  EMBDEC Combo

    EMBDEC Combo

    Items:                                  
    ReleaseProdcuts (Dynamics Table), Items (Value): 'Item Number'
    DefaultSelectedItems:         
    Table({Result: ThisItem.EMBDecorID}) (its shows as Table)

    MustH_0-1666527962905.png

     

    When using Patch 

    I am not able to Save that Combo Selection into my Text column of SharePoint list

    any Help!!

  • WarrenBelz Profile Picture
    146,743 Most Valuable Professional on 22 Oct 2022 at 20:59:07
    Re: Editable Grid PowerApps Combo Problem

    @MustH ,

    Is this a single or multiple selection and what are the Items of the Combo Box ? What is the connection between EMBDecorID and 'Item No'

  • MustafaHussain Profile Picture
    173 on 22 Oct 2022 at 20:17:25
    Re: Editable Grid PowerApps Combo Problem

    Yes @WarrenBelz 

    Your assumptions are correct, but the issue is in the
    DefaultSelectedItems:   
    Table({Result: ThisItem.EMBDecorID})    // This Data Type is a Table ( which I can't save it into SP)

    kindly see my screenshots

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started
Loading started