@AlwynSchutte
To make your temporary measure better, you can try this:
//pseudocode - not tested
ClearCollect(tempCollect,{})
ForAll(Sequence(CountRows(Gallery1.AllItems)),
Select(Gallery1,CountRows(tempCollect));
Collect(tempCollect,{});
Patch(Applications,First(Filter(Applications,'Contact ID'=Gallery1.Selected.Website_ID)),{'Assessment form1':Gallery1.Selected.Form_URL});
)
I did not test the above, I do not know if it even works.
Even if it somehow works, the above is not a good practice at all, it's just something quick in case you need it in a hurry or something.
I strongly recommend that you check with @WarrenBelz further on why your issue is occurring.
You should figure out why the formula @WarrenBelz gave originally was not working in your case. I would like you to double check and make sure you did use the original formula given exactly, and that (if needed) you used appropriate values for your scenario.
I could not see any issue with the formula really, it looks like it should work to me.
However, if it is still not working in your case, even after you checked it again, I would ask you to check with @WarrenBelz for any further questions on this specific thread, as I do not have much time at the moment to go into an in-depth testing of the formula, ForAll, Gallery.AllItems, etc. for the possible causes of this specific issue.
In order to see if there is some issue, I would need to do some checking in-depth, and it's something I'm not available to do at the moment, so please check with @WarrenBelz for any further assistance on this issue, if it persists.
I hope the revised temporary measure I gave may help you, for the very short term.
