Answered

Gallery failed to display on Sharepoint Form (OnEdit mode)

(0) Share

Report

Posted on by SMW1

Hi there,

I'm customising a sharepoint form via power apps, and attempted to add two galleries - one as a sub-form for users to enter new update (Collection - data feed to a different sharepoint list - List A), and another one to display previous updates (records for the sharepointform ID from List A).

I set the items property for 'Previous Update' gallery as

(Filter('List A', Title = SharePointForm1.LastSubmit.ID)

OnSuccess for the Sharepointform, I used this formula -

ForAll(UpdateCollection, If(!IsBlank(LineItem), Patch('List A', Defaults('List A'), {'Update Item': LineItem, 'Update By': LineBy, Title: SharePointForm1.LastSubmit.ID})))

For the 'save' - disk icon, OnSelect is expressed as

Patch(UpdateCollection, ThisItem, {LineItem: TextInput2.Text, LineBy: Dropdown1.Selected.Value})

What do I need to do to bring up the 'Previous Update' gallery when a user chooses to 'Edit' an existing Sharepoint form? Thank you.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

renatopc84_ch 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SMW1
The Form has a property.

The code you need must be inserted in the Visible property of the "Previous Update" gallery

If(FormName.Mode.Edit, true, false)
SMW1 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your advice. Perhaps I didn't make myself very clear previously. If I had to make a 'Quick Edit' to an existing form, what can I do to bring the 'Previous Updates' gallery in display (filtered to the form ID), so that I can see what are the previous updates before I insert a new update?
Thanks.

best wishes,
SMW
renatopc84_ch 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SMW1
Sorry, so if I understood it right. The user click on a Sharepoint Item and in View Mode they see the "current" version of the item.
Then in Edit Mode you would like to recall the previous version in this gallery.
If I understood it right, in your Sharepoint List you have many version of the same item only with a different ID.
Is it correct?

Otherwise if you would like to work with previous version of one Sharepoint Item using the Versioning, you will need a Flow that extract the previous version with a Sharepoint HTTPS Request.

Which is the correct case?
SMW1 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, with my limited knowledge in Power Apps, I thought each Sharepoint item will only have a unique ID (didn't consider the versioning at all!)

In response to your question,
'The user click on a Sharepoint Item and in View Mode they see the "current" version of the item.
Then in Edit Mode you would like to recall the previous version in this gallery.
If I understood it right, in your Sharepoint List you have many version of the same item only with a different ID.
Is it correct?'

Yes, Sharepoint item is on the master list whereas the gallery contains items from List A, which is linked to the master list ID. My understanding is Sharepoint item on the master list will have an automated ID unique to that item. In the Edit Mode, I'd like to recall existing items on List A linked to the unique ID of that particular Sharepoint item on the master list.

Does that make any sense to you? Thanks.
Verified answer

renatopc84_ch 228 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SMW1
Yes it make sense, I used the previous version with the Flow, but is still not a 100% working solution.

So I find your solution with a second list that stores all updates, a good workaround.

The point is that the Form has 3 modes: Edit, New, View.

Basically you could let the "Previous Updates" gallery always visible and block it with a property in displaymode like Displaymode.View.

So is always visible, but cannot be edited. The formula of the gallery should be correct as you already did.
SMW1 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your advice. I'll give it a go using Flow.