Collecttions, Galleries and Editing and Saving Collections

[Anonymous]

Hello,

Many of you have been tremendous help to me recently, so I am back for more. My app has a form, partially shown here, and one of the pieces of data collected is RAID (Risk, Assumption, Issue, Decision) as a dropdown list.

This form is for project challenges and any given project can have up to four challenges, so I am using a collection to collect the data:

The red arrow shows the collection item for RAID, which is different than the other (text) inputs, as RAID uses ***.Selected as opposed to ***.Selected.Text. This provides a record to the collection, which troubles me, but it works okay, and writes to the SharePoint list fine. If I use something other than this I get an error message and the collection won't save back to SP list.

The problem is I write this collection to a new sheet as a gallery and have an edit area on that sheet where the user can review their challenges and edit them prior to saving to SharePoint. The problem is I can't get the edit form on this new sheet to show the selected RAID, as it says it expects a record but it is text instead. I can't get the gallery RAID value to show in this edit field either.

Can anyone help with this problem? I would greatly appreciate suggestions.

Craig

[Anonymous]

Collect(collChallenges, {ID: Max(collChallenges, ID) + 1, Title: ChallNewTitleValue.Text, ProjectName: ChallNewProjNameText.Text, RAID: ChallNewRaidDropdown.Selected.Value, Subject: ChallNewSubjectValue.Text, Owner: ChallNewOwnerValue.Text, Commentary: ChallNewCommentaryRTE.HtmlText, Elevated:ChallNewElevatedDropdown.Selected.Value, ProjectId: ChallNewProjectIdText.Text });

[Anonymous]

Hi Warren,

If you are up for another question, here goes. My landing screen has a gallery consisting of certain information on about 800 projects from a 'Projects' SP list as data source. I have a Project Status screen that has a gallery that uses a 'Status' SP lists as a data source, and a Status Form on that screen that uses the same 'Status' list as it's data source. When a user selects a project from the landing gallery the app navigates to the Status screen and, if the project name selected from the gallery matches a project name from the 'Status' SP list, the Status gallery shows that one project, and the form pulls all the status info for that project into the form and shows it in View Mode, with the option for the user to switch to Edit Mode and save the edited data back to the list.  If there is no match the form opens in New Mode, with the Project Name and Project ID filled in. 

Here is the issue.  When the app if first opened and a project is selected that already has Status info the app works as planned. The Status form opens in View mode with all the status information for that project. However, if I click the home button and select a different project that also already has Status info, the app navigates to the form, the Status gallery indicates the new project name, but the Status form briefly shows the previous project status info before changing to a blank form indicating nothing to show. If I click home again, and select the new project again, the app works as hoped, showing all the newly selected project information. 

Can you tell me why this happens and how to fix it?

[WarrenBelz]

Hi @Anonymous ,

You have an ID in collChallenges - it is the first item created 

Collect(
   collChallenges, 
   {
      ID: Max(collChallenges, ID) + 1, 
      Title: ChallNewTitleValue.Text, 
      ProjectName: ChallNewProjNameText.Text, 
      RAID: ChallNewRaidDropdown.Selected.Value, 
      Subject: ChallNewSubjectValue.Text, 
      Owner: ChallNewOwnerValue.Text, 
      Commentary: ChallNewCommentaryRTE.HtmlText, 
      Elevated:ChallNewElevatedDropdown.Selected.Value, 
      ProjectId: ChallNewProjectIdText.Text 
   }
);

The remove code has to work if initiated from an icon/button in the gallery.

RemoveIf(
   collChallenges,
   ID=ThisItem.ID
)

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.

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

The first places to look should be

1. Your Navigation code to the screen
2. The OnVisible code on the screen
3. The Item and DataSource of the form

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.

[Anonymous]

Yes, that first ID code is what I created based on the information you provided, added that to the Remove code and it worked perfectly. Thanks for the new knowledge.

[WarrenBelz]

Thanks @Anonymous ,

You have the option of accepting the second solution also as it is a different subject.

[Anonymous]

Hello Again Warren:

I am in need of your help yet again. I think this will be easy for you. I have a SharePoint list where one of the columns is 'Site', a Choice field. I want to bring a distinct list of all entered Sites into a collection, which I will then use to populate a Combo Box to control shown items in a gallery. To start the building process I have this formula:

ClearCollect(collFinSite, 'GMI Workstream Financial Targets'.Site)

Of course, this gives me a collection of one column tables as opposed to the fields.

What should I add, or how should I change, to get a collection of items in the Site column of the List?

Beyond that, I am then looking to add 'Select All' to the collection and make it a collection of distinct Sites and order it alphabetically but with 'Select All' at the top. 

Can you help me?

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

This should do the job

ClearCollect(
   collFinSite,
   {Result: "Select All"}
);
Collect(
   collFinSite,
   Sort(
      Distinct(
         'GMI Workstream Financial Targets',
         Site
      ).Result,
      Result
   )
)

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.