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?
Solved! Go to Solution.
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.
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
187 | |
82 | |
50 | |
37 |
User | Count |
---|---|
288 | |
243 | |
123 | |
75 | |
56 |