Trouble with ForAll patching

(0) Share

Report

Posted on by GreenFrog

Hi,

I would be grateful for any help on ForAll query as I have spent days looking at this and not getting very far.

i have three related dataverse tables, Animals, AnimalMedicine, and AnimalMedicineLookup.

the Animal table has a ID, Name and Diseases (multi choice).

the AnimalMedicine table has ID, AnimalMedicineLookupID (lookup), Name (lookup), MedicineDescription columns.

The AnimalMedicineLookup table has AnimalMedicineLookupID, Diseases (multi choice), MedicineDescription columns.

The aim is once a user selects a Name in the Animal gallery, they are taken to a new screen where they can view all the Medicines that are related to the diseases for their selected Animal. I need to filter the diseases of that Animal from that AnimalMedicineLookup table and then patch it into the AnimalMedicine table so I can use the data in a gallery in a new screen.

First of all I have started a collection to collection all diseases of the selected animal.

ClearCollect(colDiseases, ThisItem);

then obtained the relevant columns

ClearCollect(colDiseasesRelevant, ShowColumns, Diseases);

then I have filtered the medicines from the MedicineLookup table and then stored in a new collection.

ClearCollect(colResults, []);

ForAll(

colDiseasesRelevant,

With(

{matchedRecord: Lookup(colDiseasesRelevant, Diseases = AnimalMedicalLookup.Dieases)},

If(

Is Blank(matchedRecord),

Collect(colResults,

{AnimalMedicineLookupID: ThisRecord}
)

)

Any help would be very, very appreciated. thank you 🤩

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

kelseytran 292 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @GreenFrog ,

The steps you can do for this are create a collection, extract the relevant columns, filter & collect the matching records, then patch the matching records. Here's an example of how you can do this:
Clear(colResults); ForAll( colDiseasesRelevant, // Filter AnimalMedicineLookup table for matching diseases With( { matchedRecords: Filter( AnimalMedicineLookup, ThisRecord.Diseases in AnimalMedicineLookup.Diseases ) }, Collect( colResults, ForAll( matchedRecords, { AnimalMedicineLookupID: ThisRecord.AnimalMedicineLookupID, Name: ThisRecord.Name, // Assuming Name is a field in AnimalMedicineLookup MedicineDescription: ThisRecord.MedicineDescription } ) ) ) ); ForAll( colResults, Patch( AnimalMedicine, Defaults(AnimalMedicine), { AnimalMedicineLookupID: AnimalMedicineLookupID, Name: Name, // Assuming Name is a field in AnimalMedicine MedicineDescription: MedicineDescription } ) );
You'll need to change some of the names to accurately reflect your data.
------------------------------------------------------------------------------------------------------------------------------
If I answered your question, please accept my post as a solution and if you liked my response, please give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
GreenFrog 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

thank for looking into my problem. Power Apps does not seem to like the filter in the with statement. Do you have any other ideas. Thanks

Was this reply helpful? Yes No