Update Gallery Items based on drop down list control selected value

(0) Share

Report

Posted on by CU20081036-0

183

Hi Team,

I have gallery which is tied to a SharePoint list. It has a drop down list control in each row. If drop down list status is set to "Yes", two fields have to updated in SharePoint list and if drop down list status is set to "No"/"No-Not Available"/"No-Not Applicable", four fields have to updated in SharePoint list.

I tried the following expression. The second expression does not get executed at all. Could someone guide me on this please?

ForAll(Filter(gallery.AllItems, "No" in ddlStatus.Selected.Value),
UpdateIf(
'DataSource', ID = Value(lblItemID.Text),
{'Column1': "Text"}
)
);ForAll(Filter(gallery.AllItems, ddlStatus.Selected.Value = "Yes"),
UpdateIf(
'DataSource', ID = Value(ItemID.Text),
{'Column1': "Text"', 'Column2': 'Column3': "Text",'Column4': "Text"}
)
)

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @sunithav

Please provide a screenshot of your gallery. I cannot tell from your description what you are trying to do.

Was this reply helpful? Yes No
CU20081036-0 183 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp ,

Thanks for checking this post. Here is the screenshot of the gallery which is connected to a SP list. There is a drop down list in the gallery with items ["Yes","No","No-Not Applicable","No-Not Available"]. If drop down list status is set to "Yes", save first field value in SharePoint list and if drop down list status is set to "No"/"No-Not Available"/"No-Not Applicable", save both field values in SharePoint list on Save button click.

Thanks,
SV

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @sunithav :

I've made a test but it worked well on my side:

1\My data source:

2\Add a gallery(gallery) and set it's items property to:

DataSource

3\Add a label control(lblItemID) into this gallery and set it's text property to

ThisItem.ID

4\Add a combobox(ddlStatus) into this gallery and set it's items property to

["Yes","No","No-Not Applicable","No-Not Available"]

5\Add a button control and set it's OnSelect proeprty to(I noticed that the formula you provided may have some errors, I have marked them in red):

ForAll(Filter(gallery.AllItems, "No" in ddlStatus.Selected.Value),
UpdateIf(
'DataSource', ID = Value(lblItemID.Text),
{'Column1': "Text"}
)
);ForAll(Filter(gallery.AllItems, ddlStatus.Selected.Value = "Yes"),
UpdateIf(
'DataSource', ID = Value(lblItemID.Text),
{'Column1': "Text", 'Column2': "Text",'Column3': "Text",'Column4': "Text"}
)
)

In addition,you can also try this formula to submit:

ForAll( gallery.AllItems, If( "No" in ddlStatus.Selected.Value, UpdateIf('DataSource', ID = Value(lblItemID.Text),{'Column1': "Text"}), "Yes" in ddlStatus.Selected.Value, Patch('DataSource', LookUp('DataSource',ID = Value(lblItemID.Text)),{Column1: "Text", Column2: "Text",Column3: "Text",Column4: "Text"}) ) )

Or

ForAll(Filter(gallery.AllItems, "No" in ddlStatus.Selected.Value), UpdateIf( 'DataSource', ID = Value(lblItemID.Text), {'Column1': "Text"} ) );ForAll(Filter(gallery.AllItems, ddlStatus.Selected.Value = "Yes"), Patch( 'DataSource', LookUp('DataSource',ID = Value(lblItemID.Text)), {Column1: "Text", Column2: "Text",Column3: "Text",Column4: "Text"} ) )

These formulas also worked well on my side

Best Regards,

Bof

Was this reply helpful? Yes No