Answered

Retriving data back from multiple lists to edit

(0) Share

Report

Posted on by Jiis

254 Moderator

Im trying make a function where you can edit already done inspections, im trying to retrive data back from 3 lists, and decided to retrieve them back into collection.

How can get "Answer" value to be correct for each record ,right now with this formula it gets the value of the first record in 'Inspection answers' and puts it on all records in the collection

This formula is in a gallery onselect on an already done inspection

ClearCollect(
 colQuestionsEdit,
 AddColumns(
 ShowColumns(
 QuestionList,
 "ID",
 "Title",
 "TitleENG",
 "TitleRU",
 "Requirement",
 "RequirementENG",
 "RequirementRU",
 "Value",
 "Order" ),
 "Answer",
 LookUp('Inspection answers',ThisItem.ID=ResponseID).Answer,
 "Values",
 "",
 "Comment",
 "",
 "Score",
 "",
 "MinusScore",
 ""
 )
);

I assume it can be done with ForAll, but i dont know how to integrate it

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

WarrenBelz 156,293 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Jiis ,

Try this

ClearCollect( colQuestionsEdit, AddColumns( ShowColumns( QuestionList, "ID", "Title", "TitleENG", "TitleRU", "Requirement", "RequirementENG", "RequirementRU", "Value", "Order" ), "Answer", LookUp('Inspection answers',ResponseID = ID).Answer, "Values", "", "Comment", "", "Score", "", "MinusScore", "" ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Thank you for replying
This does not seem to work. Now im getting "?" in my records. In here ResponseID and ID are being compared and i think they come from the same list, ThisItem.ID comes from another list.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,293 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Jiis ,,

Where are you running this from as a ThisItem reference needs to be inside a Form or a Gallery. The problem is if you refer to ThisItem.ID, you will always get the same record reference. Usually with AddColumns, you would need to refer to the ID of each record (so just plain ID) so each could look up the other list.

I am now quite unclear what you are trying to achieve here.

Was this reply helpful? Yes No
Verified answer

Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz
Thank you for making me realize, I found the solution, i had two mistakes, since ID column exists in every list lookup didnt know which one to pick, so i renamed the id column. And also i didnt make the connection between Question Id and Answer ID, this is the formula
ClearCollect( colQuestionsEdit, AddColumns( RenameColumns( ShowColumns( QuestionList, "ID", "Title", "TitleENG", "TitleRU", "Requirement", "RequirementENG", "RequirementRU", "Value", "Order" ), "ID", "IID" ), "Answer", LookUp( 'Inspection answers', IID = QuestionID && ThisItem.ID = ResponseID ).Answer, "Values", "", "Comment", "", "Score", "", "MinusScore", "" ) );

Was this reply helpful? Yes No