view a text item in a column

(0) Share

Report

Posted on by ShaneITAutomate

301

Hi,

I have a canvas app that connects to a database that each column is in text, in my canvas app i have built dropdowns that are filled from a collection made in the app, if i want to patch them i have a label that is invisible that displays the value of the dropdown. But how do i edit the value of the item (default gallery.selected.itemiwanttochange) when i select it from the gallery and for correct item to be displayed in the dropdown? ive done this before however i cannot remember how?

Cheers

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@ShaneITAutomate

If the control doing the patch is outside of the gallery:

Patch(table,Lookup(table,ID=Gallery1.Selected.ID),{itemiwanttochange:Textinput1.Text})

If it is inside the gallery

Patch(table,Lookup(table,ThisItem,{itemiwanttochange:Textinput1.Text})

Was this reply helpful? Yes No
ShaneITAutomate 301 on at

Like (0)

Report
Copy link

Link copied!
Sorry im confused>?

Im trying to edit my gallery data that is saved as Text back into a dropdown?

Eg i have a dropdown with the items colItems, i view the itemname but i patch the itemcode

ClearCollect( coltems, { Id: 0, itemcode: "", itemname: "" }, { Id: 1, itemcode: "A1", itemname: "TESTNAME" }, { Id: 2, itemcode: "A2", itemname: "TESTNAME2" } )

i collect the dropdown to another collection ill call colAll (with many others)

Collect( colAll, {ListItem:Text(dropdown1.Selected.itemcode))

ColAll has yet to be patched back to sharepoint which is a text column,
if i goto the gallery and decide to edit those values i wish to edit them back in a dropdown where i view the itemname again,

Was this reply helpful? Yes No