Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Larry Burgess]

This one has me baffled.  This is code that has worked flawlessly for over 18 months that is suddenly failing with the following runtime error:

“The requested operation is invalid. Server Response: [SPO datasource name] failed: Fetching items failed. Possible invalid string in filter query.”

I’m updating a SharePoint list from a collection.  Here’s a snippet of the code:

ForAll(
colIndStateLicensingApproved,
Patch(
‘Individual Licensing States Licensed’,
LookUp(‘Individual Licensing States Licensed’,ID = colIndStateLicensingApproved[@ID]),
{
Title: Title,
StateLicensed: StateLicensed,
StateLicenseStatus: StateLicenseStatus,
StateLicenseNumber: StateLicenseNumber,
StateLicenseStatusDate: StateLicenseStatusDate,
OriginalLicenseDate: OriginalLicenseDate,
InterlincLicenseDate: InterlincLicenseDate,
CEYear: CEYear,
CEDateCompleted: CEDateCompleted,
RenewalYear: RenewalYear,
RenewalStatus: RenewalStatus,
RenewalStatusDate: RenewalStatusDate,
TerminatedInNMLS: TerminatedInNMLS,
NMLSTerminationDate: NMLSTerminationDate,
ProspectIUpdatedFiling: ProspectIUpdatedFiling,
ProspectSponsored: ProspectSponsored
}
)
);

When I replace colIndStateLicensingApproved[@ID] with a hard-coded id, the code works.  I thought disambiguation was supposed to handle this situation – and it has until now.

What am I missing?

——————————
Larry Burgess
Developer
Interlinc Mortgage Services
Houston TX
281-210-5669
——————————

[Will Page]

Try replacing colIndStateLicensingApproved[@ID] with ThisRecord.ID

——————————
Will Page
Technical consultant
Christchurch, NZ
——————————
——————————————-

[Warren Belz]

Hi Larry,

Another thought – lots of Ambiguity in there – try an As statement

ForAll(
   colIndStateLicensingApproved As Approved,
   Patch(
      'Individual Licensing States Licensed',
      {ID:Approved.ID},
      {
         Title: Approved.Title,
         StateLicensed: Approved.StateLicensed,
         StateLicenseStatus: Approved.StateLicenseStatus,
         StateLicenseNumber: Approved.StateLicenseNumber,
         StateLicenseStatusDate: Approved.StateLicenseStatusDate,
         OriginalLicenseDate: Approved.OriginalLicenseDate,
         InterlincLicenseDate: Approved.InterlincLicenseDate,
         CEYear: Approved.CEYear,
         CEDateCompleted: Approved.CEDateCompleted,
         RenewalYear: Approved.RenewalYear,
         RenewalStatus: Approved.RenewalStatus,
         RenewalStatusDate: Approved.RenewalStatusDate,
         TerminatedInNMLS: Approved.TerminatedInNMLS,
         NMLSTerminationDate: Approved.NMLSTerminationDate,
         ProspectIUpdatedFiling: Approved.ProspectIUpdatedFiling,
         ProspectSponsored: Approved.ProspectSponsored
      }
   )
)?

——————————
Warren Belz
Queensland Australia
——————————
——————————————-

[Larry Burgess]

the “As” statement did it!  It took me a couple of tries.  Apparently I typed something incorrectly the first couple of times.  Persistence paid off and now it’s working.  I still don’t understand why it worked for 18 months then suddenly stopped.  Oh well, such is life!

——————————
Larry Burgess
Developer
Interlinc Mortgage Services
Houston TX
281-210-5669
——————————
——————————————-

[Larry Burgess]

Will, that gives me the same error.  The “As” statement that Warren suggested seems to have done it.

——————————
Larry Burgess
Developer
Interlinc Mortgage Services
Houston TX
281-210-5669
——————————
——————————————-

[Charles Palmer]

Hi,

Had something similar  – existing App, working for more than a year, suddenly stopped, exactly the same scenario – matching multiple collection items using ForAll. 

Ended up here on Google, and interesting that things happening at the same time.

I am using a secondary field to hold an internal reference to match on – which happens to be a GUID type string in a text field, but which has never been an issue before.

As suggested above things worked if I hard coded my filter values on either my internal reference or the ID fields.

I’ve had to use GUID() in the ForAll/Patch/Filter steps for the filter to work.

First(Filter(Works, GUID(job_id) = GUID(_offlineUpdateWork.job_id)))

UpdateContext(
{
_patchUpdateMaintResult: ForAll(
  _offlineUpdateWorks As _offlineUpdateWork,
  Patch(
   Works,
    First(Filter(Works, GUID(JobId) = GUID(_offlineUpdateWork.JobId))),
    {
      Title: _offlineUpdateWork.Title,
      Description: _offlineUpdateWork.Description,
      Rating: _offlineUpdateWork.Rating,
      Comments: _offlineUpdateWork.Comments,
      Site: _offlineUpdateWork.Site,
      Status: _offlineUpdateWork.Status,
      BeforePhoto: _offlineUpdateWork.BeforePhoto,
      AfterPhoto: _offlineUpdateWork.AfterPhoto,
      CompletedDate: _offlineUpdateWork.CompletedDate,
      CheckUser: _offlineUpdateWork.CheckUser
     }
   )
  )
 }
)

(just in case it helps anyone else, as I’ve spent time trying various things / googling for ideas)

Charles.

——————————
Charles Palmer
IT Manager
——————————
——————————————-

[Rob Clark]

Apparently I cannot delete a post. I had speculation, but the problem has already been resolved I see.