Canvas app to havea button to update an existing item at sharepoint list

(0) Share

Report

Posted on by kouliscon

247

hello all

I made an empty canvas app and I added an edit form and a button and i would like when I complete some fields and press the button I would like to update an existing item at my SharePoint list.

if I use SubmitForm(formname) that will create another item at the SharePoint list which I don't want that.

any ideas?

Categories:

General Questions

Connecting to Data

All responses (6)

Answers (1)

Verified answer

kouliscon 247 on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

hello,

I made my app based on this video: Power Apps: Open App with SharePoint List Formatting and specifically:
- APP section at the left at ITEM: if(!IsBlank(Param("ID")),Set(varID, Param("ID"));Navigate(Screen,ScreenTransition.Fade))
- then at each of the two forms:
- formView
- formEdit
at the ITEMS I added: FormView: If(!IsBlank(Param("ID")),LookUp('Summer Associate',ID = varID))

and lastly at the button: SubmitForm(FormEdit); Navigate(Submitted)

and that seems to did the trick.

thanks
v-siky-msft on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

Hi @kouliscon ,

It seems you are configure a Deep Link feature to your app.

Was the ID parameter passed successfully?

Please try to add a Label to show the Param("ID") or VarID to check if they are blank or not.

Sik
kouliscon 247 on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

thank you @v-siky-msft but that doesn't seem to work.

I do have at the button on OnSelect: EditForm(FormNew);Navigate(Submitted)
and at the ITEM of the FormNew: If(!IsBlank(Param("ID")),LookUp('SA - Test',ID = varID))

but when I press the button no values are registered...

any other ideas?
v-siky-msft on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

Hi @kouliscon ,

The Item property and the LookUp formula look great.

Please make sure the Form is in Edit Mode, you can use EditForm(FormName) formula to switch mode, or select the Edit in Default mode property directly.

Hope this helps.

Sik
kouliscon 247 on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

thank you @v-siky-msft

I followed another article which I read online of how to "Opening PowerApp using SharePoint Column Formatting"

so i have a variable with the ID of the item that i want to update. the variable is "VarID"

how can i use the variable to update that id?

at the ITEM of the form i use: LookUp('SA - Test',ID = varID) but it didnt work.

any ideas?
v-siky-msft on at

Like (0)

Report

Re: Canvas app to havea button to update an existing item at sharepoint list

Hi @kouliscon ,

You have to use a button with EditForm(FormName) code in OnSelect property to change Form into Edit Mode, and then set the specific record you want to edit into Items property of Form, then the form will show the data of specific record, and the modification will be submitted to that record.

For example, put First('SP list') into Form.Items property to Edit the first record.

Hope this helps.

Sik