cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mjdacs
Frequent Visitor

IsBlank() potential bug when pulling edit data into form

Hi All,

 

I have two identical galleries on one screen, upper and lower. The upper gallery represents "in-progress" tasks, and the lower gallery "completed". I am filtering the SharePoint List for today and whether or not an EndTime value is blank, using IsBlank() or !IsBlank().

 

SortByColumns(
    Filter(
        <dataset>,
        And(StartTime >= Today(), !IsBlank(EndTime)) // for lower, IsBlank(EndTime)for upper
    ),
    varSortBy,
    If(SortDescending1, Ascending, Descending)
)

 

When I click the edit button in the lower gallery (completed) --  !IsBlank() -- the edit form populates the data correctly. However when click the edit form in the upper gallery (in-progress) -- IsBlank() -- the form is populated with data from another record in the SP List, seemingly the most recent record that was pulled into the edit form.

 

Additionally, if you only sort for StartTime alone (and remove the IsBlank()/!IsBlank code), the in-progress records populate the edit form correctly.

 

Has anyone been confronted with this issue or can also replicate it?

1 ACCEPTED SOLUTION

Accepted Solutions
mjdacs
Frequent Visitor

Just figured it out. The Items section in my form was pointing to only the lower gallery. When I use a conditional in the Items section to toggle between the upper and lower galleries, it works.

View solution in original post

1 REPLY 1
mjdacs
Frequent Visitor

Just figured it out. The Items section in my form was pointing to only the lower gallery. When I use a conditional in the Items section to toggle between the upper and lower galleries, it works.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (25,614)