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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No