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

All responses (10)

Answers (0)

Sort by

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Not wroking.
Thanks anyway.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Linda777 ,

Did you try what I suggested?
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

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
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Linda777 ,

Where you have your code. Also try a SharePoint view that is not Grouped.
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,
it is not grouped. it is not working thanks anyway.
.
tyanawhite 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
Linda777 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I just restore the previous version app. good luck!
natashagondi 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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