Hello All,
I have a datasource which contains a column -"Summary" against each Project example like below:
| Project | Summary |
| ABC | ISS-00012 : Completed ; SCP00001 : Not Applicable ; QM7484474 : Plan TBD ; SCP00004 : Not Applicable ; QRCM7556800 : Not Applicable ; |
| XYZ | ISS-00012 : Agree not to fix ; SCP00001 : Planned ; QM7484474 : Plan TBD ; SCP00004 : Completed ; QRCM7556800 : Not Applicable ; |
| RST | ISS-00012 : Blocked ; SCOOP00001 : Not Applicable ; QM7556800 : Not Applicable ; QRCM7484474 : Plan TBD ; SCP00004 : Not Applicable ; |
I have two gallerys, where first part of summary Id's matches (ISS-00012 will be present in two gallerys). Now I want to create a drop down when ISS-00012 is selected in first gallery I want to save relevant status for that ID from second gallery.
I mean if I select one status for one Issue-ID then it should either add newly or replace the current status of that issue-ID.
ISS-00012 : Completed; Now lets say this goes and store inside the first row of Summary column against project ABC.
1. Similarly, I need to update the status for other Issue-IDs as well in against same project ABC. And this repeats for other projects rows and its IDs +status. Is there is any way to find solution for this?
2. And if I want to replace that current status of "ISS-00012 : Completed "with "ISS-00012 : Blocked". what is the logic for it without disturbing other IDs in that row ??
I tried below logic but whatever I do the whole "Summary" column first row data is getting replaced with only one ID+status out of 10 IDs+Status.
Patch(
PrjFile_1,
SecondGallery.Selected,
{
Summary: Substitute(LookUp(Split(ThisItem.Summary," ; "),FirstGallery.Selected.'Issue-ID' in Value,Value),
Mid(ThisItem.Summary,Find(FirstGallery.Selected.'Issue-ID'&" "&":"&" ",ThisItem.Summary)+Len(FirstGallery.Selected.'Issue-ID'&" "&":"&" "),
Find(" ; ",ThisItem.Summary,Find(IFirstGallery.Selected.'Issue-ID'&" "&":"&" ",ThisItem.Summary)+Len(FirstGallery.Selected.'Issue-ID'&" "&":"&" "))-(Find(FirstGallery.Selected.'Issue-ID'&" "&":"&" ",ThisItem.Summary)+Len(FirstGallery.Selected.'Issue-ID'&" "&":"&" "))),
ComboBox2_1.Selected.Status)
}
)
I am not sure how to fix this. Any help would be of greatly appreciated.
@WarrenBelz , @FLMike : have you gone through this kind of problem statement ??
