Forum Discussion

MarcPuig's avatar
MarcPuig
Copper Contributor
Feb 24, 2025

Sharepoint not refreshing on edit and submit a new form

I'm working in a portal with 3 lists (Risks, Controls and Action Plans) where I need to have a reference in each list of other columns in the other two lists.

I have 2 lookups pointing the other lists in each list and the txtContent is showing the number of rows are related.

The prblem is that i have a gallery view with an Edit button, and when i edit this columns adding a new reference, the view shows 0 in associated Risks and Associated Actions, and i haver to refresh the page to see the real number of rows related.

 

Initial Gallery Value:

Edit Form:

- Initial Values

- Edited Values

Final Gallery Value:

 

 

Some help?

developer
microsoft lists
SharePoint Online
  • Brent Hutchings's avatar
    Brent Hutchings
    Copper Contributor
    Feb 25, 2025

    You mentioned "..a gallery view with an Edit button" are you updating the record in Power Apps or the native SharePoint list form?

    I suspect you may be using a Power App form since you mentioned a Gallery. If you are doing this in Power Apps I found you have to use the following in the Update Property for a Combo Box so it sends back to the SharePoint list the correct format since your data column is a Lookup Type. Meaning a Look Up type column must receive back the ID and the Title. You can replace "DataVardValue5" with what ever your data card name is on your form.


    {

        '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

        Id: DataCardValue5.Selected.ID,

        Value: DataCardValue5.Selected.Title

    }



    View in Power App.


    Hope this helps.

Resources