I use the following and have no error but does not do anything
ForAll(Chkd1,Patch(First(Filter('CAT 2 Defence Vehicle List',ID=ID1 )),{Fone:FC1,FTwo:FC2,FThree:FC3,Fxp1:Ex1,Fxp2:Ex2,Fxp3:Ex3,Audit:"Yes"}) )
chkd is a collection
'CAT 2 Defence Vehicle List' is a sharepoint list
Both the Collection fields and the list field match with no error but it does not do anthing at all
Th eSharepoint list has 200 records so it should not be a delegation issue
Solved! Go to Solution.
While i Did not figure theissue out, I did find a simple solutions to this. I just used Flow.
Ok I have noted that the formula has diifetent names for teh fields that are in sharepoint. Eg Fone is actually 'Fuel_x0020_Card_x0020_one'
I went through an dreplace them all and it still does not work. I have also noted a difference bwteen PowerApp filed name and SharePOINt actual name in teh proprties. EG
Fuel_x0020_Card_x0020_one is =Fuel%5Fx0020%5FCard%5Fx0020%5Fone in SharePoint. I assume the %5Fx0020%5F is a space as is _x0020_ in Poweaaps. Eitherway I cannot get this patch to work
With those changes I get a non working, no error formula of
ForAll(Chkd1,Patch(First(Filter('CAT 2 Defence Vehicle List',ID=ID1 And Title = Reg )),{Fuel_x0020_Card_x0020_one:FC1,Fuel_x0020_Card_x0020_Two:FC2,Fuel_x0020_Card_x0020_Three:FC3,OData__x0045_xp1:Ex1,OData__x0045_xp2:Ex2,OData__x0045_xp3:Ex3,Audit:"Yes"}) )
While i Did not figure theissue out, I did find a simple solutions to this. I just used Flow.
User | Count |
---|---|
260 | |
110 | |
98 | |
56 | |
40 |