Combobox will Create,Update a record.

(0) Share

Report

Posted on by nagestiada

504

Hey guys, I have a combobox with multiple choices (multiselect is on)

So for example.

on this combobox I have selected Cash and OTC

So clicking the submit button will check if Cash and OTC already exist on the Share Point If exist do nothing and if not it will create two new record one for Cash and one for OTC.

Sharepoint will look like the table below

CID	Process	Selected
123456	Cash	Yes
123456	OTC	Yes

if the user changed the combobox to select only Cash

Then clicking the submit button will update the status to Process Selected: No since the OTC is deselected.

Sharepoint will look like the table below

CID	Process	Selected
123456	Cash	Yes
123456	OTC	No

Will appreciate any help. Thank you thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @nagestiada

What you could do is that on every submit save to your table all the possible values in your combobox if they were selected or not, so that you do not need to check if value needs to be updated or not. And of course before saving you clear all existing values for this CID. So your onselect event could look like :

ForAll(YOUR_ITEMS_SOURCE_FOR_YOUR_COMBOBOX,Patch(YOUR_SHAREPOINT_LIST,{CID:CID_ID,Process:ThisRecord.Value,Selected:ThisRecord.Value in YOUR_COMBOBOX.SelectedItems}))

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report
Copy link

Link copied!

@alaabitar, Sorry I don't understand you. if we patch all possible values to the Sharepoint then the user clicked again the button then it will just duplicate the values

Was this reply helpful? Yes No
alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@nagestiada as I mentioned before saving you clear all existing values for this CID so that you won't have duplicates.

Was this reply helpful? Yes No