Unanswered

Edit form not showing data

Like (1) Share

Report

Posted on 28 Jun 2019 15:23:50 by Community Power Pla...

Hello,

When I try to edit data that's already on my sharepoint list when I click "edit" the power app opens but no data is populated. I don't want to input everything again on the form.

Please help

Categories:

General Questions

Capture.PNG

All responses (8)

Answers (0)

Pstork1 67,356 Most Valuable Professional on 08 Jul 2019 at 15:21:27

Like (3)

Report
Re: Edit form not showing data

Check the item property on the SharePoint form. It should be set to this:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('ListName'),SharePointIntegration.Selected)
If that doesn't work try changing the .Selected to .SelectedItemId
Community Power Pla... on 08 Jul 2019 at 14:57:42

Like (0)

Report

Re: Edit form not showing data

@Pstork1 When I want to add new data to the sharepoint list I click on New and a blank power app opens up.... so I add all the data into the fields. This is correct.

When I want to edit data that has already been submitted to the list and I click on the circle on the left and then edit... the power app form opens up but it opens up blank.

I dont want to input all the data again...

is there a way I can get the data thats already on the list on the form and edit the data on the power app form... I dont want to add everything all over again.

Below you'll find the picture where it shows that when I click Edit, the power app opens up but blank not with all the data

Capture.PNG
Pstork1 67,356 Most Valuable Professional on 08 Jul 2019 at 14:52:13

Like (0)

Report

Re: Edit form not showing data

When you customize the form in a SharePoint list you will automatically get a New, View, and Edit form. If they add something via the New link on the toolbar they will get the form with the default mode set to New. If they edit an existing Item they will get the form with the default set to Edit. Can you explain a bit more what you are trying to do?
Community Power Pla... on 08 Jul 2019 at 14:33:31

Like (0)

Report

Re: Edit form not showing data

@v-yuxima-msft Yes I do create a customize form. Your IF statement works only if the form deafult mode is set to "edit" but I want it to be set to new.

Every time someone adds something I want a new form but when they need to edit a row already in the list I want the form to display the values.
v-yuxima-msft on 03 Jul 2019 at 09:04:19

Like (0)

Report

Re: Edit form not showing data

Hi @Anonymous

Is it one cusomize form?

Do you create cutomize form as this?

customize-list-form

sharepoint-form-integration

Best Regards.

Yumia
Community Power Pla... on 01 Jul 2019 at 13:58:25

Like (0)

Report

Re: Edit form not showing data

@v-yuxima-msft @Pstork1 The IF statement doesn't seme to work.
v-yuxima-msft on 01 Jul 2019 at 06:49:47

Like (0)

Report

Re: Edit form not showing data

Hi @Anonymous

Could you please check whether the Item is as next screenshot shows in your customized form?

SharePointForm1.Item=If(IsBlank(SharePointIntegration.Selected)||IsEmpty(SharePointIntegration.Selected),First('2019test'),SharePointIntegration.Selected)

(2019test is the SP list name on myside, please change to yours on your side)

Best Regards.

Yumia
Pstork1 67,356 Most Valuable Professional on 28 Jun 2019 at 15:46:33

Like (0)

Report

Re: Edit form not showing data

When you are editing the form in PowerApps what is the Items property of the form? Is this a standalone PowerApp or a sharepoint integrated form?