Edit form showing the first record all the time

(0) Share

Report

Posted on by Linda777

178

@RandyHayes Hello Randy and All,

I need help with the edit form. there are two SharePoint lists

1. ListA: FormA. working fine.
2. ListB: FormB_1 & FromB_2. The SharePoint formB_1 and FormB_2 were customized via PowerApps, which has issue.
When users submit a new request with ListA (FormA), another new request for ListB (FormB_1 & FormB_2) was generated/copied by Flow in the backend.

No Galleries. ListA works fine. ListB works until I added a new item to FormB_2, and published it. then when creating new records in ListA (FormA), no matter which record I open by clicking on the "Edit" button in the SharePoint listB, the edit form is showing data for the first record in my SharePoint list and not for the current record I selected. for the existing records, works fine.

The Item property of forms (FormB-1 & FormB_2) is set to:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First(ListName),SharePointIntegration.Selected)

I tried to change it to:

1. If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),

LookUp(ListName,ID= SharePointIntegration.SelectedListItemID),

SharePointIntegration.Selected)

2. If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),Defaults(istName),SharePointIntegration.Selected)

3.Last(FirstN(YOUR_LIST_NAME, SharePointIntegration.SelectedListItemID))

4,SharePointIntegration.Selected
5. Tried to add

OnSuccess action of the formB_1 and FormB_2 : Set(glbCurrentRecord, Self.LastSubmit)
and changed the Form Item property to: glbCurrentRecord
(not working, I think because FormB_1 and FormB_2 were created by flow.)

Any help to fix this will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report
Hi @Linda777 ,

This is a bug we struck a little while back on lists with some users when the view was grouped. To test this theory, ungroup (do not group) a list and see if it works.

Also try

With( {wID: SharePointIntegration.SelectedListItemID}, If( wID > 1, LookUp( ListName, ID = wID, ), First(ListName) ) )

which should address a current bug on Delegation of SharePointIntegration.SelectedListItemID.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Linda777 178 on at

Like (0)

Report

Hi Warren,
I tried
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
LookUp(ListName,ID= SharePointIntegration.SelectedListItemID),
SharePointIntegration.Selected)

Not wroking.
Thanks anyway.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (1)

Report

@Linda777 ,

Did you try what I suggested?

Was this reply helpful? Yes No
Linda777 178 on at

Like (0)

Report

Hi Warren,

I tried lookup below, it is not working.
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
LookUp(ListName,ID= SharePointIntegration.SelectedListItemID),
SharePointIntegration.Selected)

CanI ask where I should put your code to? thanks

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report

@Linda777 ,

Where you have your code. Also try a SharePoint view that is not Grouped.

Was this reply helpful? Yes No
Linda777 178 on at

Like (0)

Report

Hi Warren,
it is not grouped. it is not working thanks anyway.
.

Was this reply helpful? Yes No
tyanawhite 2 on at

Like (0)

Report

Hi,
I am having this exact same issue with 2 different PowerApps forms that use 2 different Sharepoint lists. Neither list is using any kind of grouped view. Any help would be appreciated!

Was this reply helpful? Yes No
Linda777 178 on at

Like (0)

Report

Hi, I just restore the previous version app. good luck!

Was this reply helpful? Yes No
natashagondi 6 on at

Like (0)

Report

Hi,

Did anyone find solution for this ? I am facing the same issue.
Display form of all the items in the SharePoint list only displays the data of the first item.
I have customized forms using PowerApps canvas App.

Any help is greatly appreciated.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.

Was this reply helpful? Yes No