web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calling on a specific ...
Power Apps
Unanswered

Calling on a specific item from a Collection

(0) ShareShare
ReportReport
Posted on by JeckGill 242

I want to populate a table with specific data from an app - is there a way I can tell a patch to take a specific entry on a collection. For example:

JeckGill_0-1695112145811.png

I want to use the "2" from "Rest Room/Canteen" in the following expression:

 

 

ForAll(col_actionRequired,
 Patch(
 'Form - Site Inspection Reports',
 Defaults('Form - Site Inspection Reports'),
 {
 'Primary Key': _formName,
 Name: _uploaderName,
 'Project Number': _projectNumber,
 Signature: signatureOutput.Image,
 'Problem Area': problemArea,
 'Action Required': actionRequired,
 'Have the changes been made?': "No",
 'Rest Room / Canteen': col_combined.XYZ
 
 } 
 )
);

 

 

is this possible?

Categories:
Building Power Apps
I have the same question (0)
  • vaubeee Profile Picture
    vaubeee 533 on at

    Hi @JeckGill 

    'Rating Score': ThisRecord.RatingScore, 

    or 

    'Rating Score': col_combined[@RatingScore], 

    should work.

     

    ------------------------------------------------------------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

  • JeckGill Profile Picture
    JeckGill 242 on at

    so for the last line in that expression I have

    'Rest Room / Canteen': col_combined.XYZ //where col_combined.XYZ would be the collection entry marked as "2"


    I don't want 'Rating Score' to be put through, just the score itself  

  • timl Profile Picture
    timl 36,785 Super User 2026 Season 1 on at

    @JeckGill 

    >>I don't want 'Rating Score' to be put through, just the score itself

    With regards to this, where do you store the 'score itself'? Is this a column in your col_actionRequired collection? If so, can you post the contents of this collection?

     

     

  • JeckGill Profile Picture
    JeckGill 242 on at

    JeckGill_0-1695115803338.png

    the collection is quite large - so I wouldn't be able to post all entries; hence why I only put a snippet of them earlier. Here are more of the entries just so you have an idea.

     

    There are 49 items, they get rated either N/A or 1-5. All of them need to be uploaded and they have their own column that they correlate with in the PowerApps table.

    JeckGill_1-1695115922544.png

     

    my plan was to just take the rating value from the collection based on it's location (they should always be created in the same order, I can't see why they wouldn't so it was the best way I could think of doing this), and patch that through to the table

  • timl Profile Picture
    timl 36,785 Super User 2026 Season 1 on at

    @JeckGill 


    Thanks for the explaination. Just to clarify my understanding, you'd like to Lookup the value of RatingScore in col_combined, where the RatingTitle equals "Rest Room/Canteen" (ie, 2) and to patch this to 'Form - Site Inspection Reports'?

    If so, the syntax would look like this:

    ForAll(col_actionRequired,
 Patch(
 'Form - Site Inspection Reports',
 Defaults('Form - Site Inspection Reports'),
 {
 'Primary Key': _formName,
 Name: _uploaderName,
 'Project Number': _projectNumber,
 Signature: signatureOutput.Image,
 'Problem Area': problemArea,
 'Action Required': actionRequired,
 'Have the changes been made?': "No",
 'Rest Room / Canteen': LookUp(col_combined, RatingTitle="Rest Room / Canteen").RatingScore
 
 } 
 )
);
  • vaubeee Profile Picture
    vaubeee 533 on at

    Hi @JeckGill 

    'Rating Score': ThisRecord.RatingScore,  or  'Rating Score': col_combined[@RatingScore],  

    would patch the score value, e.g. 2, to a datasource column named "Rating score". Chose this bc no column name was provided 😉

    You can patch any column like so.

     

    Do I get it right, that every column name corresponds to the records RatingTitle in your collection?

     

    If so, this might work:

     

    ThisRecord.RatingTilte: ThisRecord.RatingScore,

     

    ------------------------------------------------------------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up. 

  • JeckGill Profile Picture
    JeckGill 242 on at

    I've been trying @timl's method - I have it almost working I think. But I have red lines under the whole patch now 😅

    I get two messages when I hover the cursor over these;
    - "The type of this argument 'gg_pub'accessegress' does not match the expected type 'OptionSetValue (Site Inspection Rating)'. Found type 'Text'.
    - "The function 'Patch' has some invalid arguments.

     

    Below is the current expression for reference:

     

     

     

    ForAll(col_actionRequired,
 Patch(
 'Form - Site Inspection Reports',
 Defaults('Form - Site Inspection Reports'),
 {
 'Primary Key': _formName,
 Name: _uploaderName,
 'Project Number': _projectNumber,
 Signature: signatureOutput.Image,
 'Problem Area': problemArea,
 'Action Required': actionRequired,
 'Have the changes been made?': "No",

 'Rest Room / Canteen': LookUp(col_combined, RatingTitle="Rest Room / Canteen").RatingScore,
 'Changing Facilities': LookUp(col_combined, RatingTitle="Changing Facilities").RatingScore,
 'General Cleanliness': LookUp(col_combined, RatingTitle="General Cleanliness").RatingScore,
 'Site offices and welfare electrical cert in date': LookUp(col_combined, RatingTitle="Site offices & welfare electrical cert in date").RatingScore,
 'First aid facilities / first aider': LookUp(col_combined, RatingTitle="First Aid Facilities/ First Aider").RatingScore,
 Washing: LookUp(col_combined, RatingTitle="Washing").RatingScore,
 Sanitation: LookUp(col_combined, RatingTitle="Sanitation").RatingScore,
 PPE: LookUp(col_combined, RatingTitle="PPE").RatingScore,
 'Fire extinguisher checked & in date - welfare': LookUp(col_combined, RatingTitle="Fire extinguisher in date & checked").RatingScore,
 'Environmental Factors': LookUp(col_combined, RatingTitle="Environmental Factors").RatingScore,
 'Accident Records': LookUp(col_combined, RatingTitle="Accident Records").RatingScore,
 'Statutory forms / registers etc. ': LookUp(col_combined, RatingTitle="Statutory forms / Registers etc.").RatingScore,
 'Access / Egress': LookUp(col_combined, RatingTitle="Access / Egress").RatingScore,
 'Signs & Notices': LookUp(col_combined, RatingTitle="Signs & Notices").RatingScore,
 'Tidiness - Storage Areas': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
 Flammables: LookUp(col_combined, RatingTitle="Flammables").RatingScore,
 Gases: LookUp(col_combined, RatingTitle="Gases").RatingScore,
 'Fuels & Lubricants': LookUp(col_combined, RatingTitle="Fuels / Lubricants").RatingScore,
 'Fire precautions - Storage Areas': LookUp(col_combined, RatingTitle="Fire Precautions").RatingScore,
 'Tools & Equipment': LookUp(col_combined, RatingTitle="Tools & Equipment").RatingScore,
 'Spillage kits': LookUp(col_combined, RatingTitle="Spillage Kits").RatingScore,
 'Access Equipment': LookUp(col_combined, RatingTitle="Access Equipment").RatingScore,
 'Dangerous Materials (COSHH)': LookUp(col_combined, RatingTitle="Dangerous Materials (COSHH)").RatingScore,
 'PAT Testing in date': LookUp(col_combined, RatingTitle="PAT Testing in date").RatingScore,
 'Quarantine Area': LookUp(col_combined, RatingTitle="Quarantine Area in place & used").RatingScore,
 'COSHH - SDS assessments': LookUp(col_combined, RatingTitle="COSHH - SDS Assessments in place").RatingScore,
 'LOLER in date': LookUp(col_combined, RatingTitle="LOLER in date").RatingScore,
 Scaffolding: LookUp(col_combined, RatingTitle="Scaffolding").RatingScore,
 'Ladders & Trestles': LookUp(col_combined, RatingTitle="Ladders / Trestles").RatingScore,
 'Working Platforms': LookUp(col_combined, RatingTitle="Working Platforms").RatingScore,
 Services: LookUp(col_combined, RatingTitle="Services").RatingScore,
 Security: LookUp(col_combined, RatingTitle="Security").RatingScore,
 'Extinguisher checked + in date - ConsAct': LookUp(col_combined, RatingTitle="Extinguisher in date").RatingScore,
 'Call points checked': LookUp(col_combined, RatingTitle="Call points checked").RatingScore,
 Electrical: LookUp(col_combined, RatingTitle="Electrical").RatingScore,
 Hoists: LookUp(col_combined, RatingTitle="Hoists").RatingScore,
 'Mobile Crane': LookUp(col_combined, RatingTitle="Mobile Crane").RatingScore,
 'Lifting Gear': LookUp(col_combined, RatingTitle="Lifting Gear").RatingScore,
 Excavations: LookUp(col_combined, RatingTitle="Excavations").RatingScore,
 Transport: LookUp(col_combined, RatingTitle="Transport").RatingScore,
 'Other Plant': LookUp(col_combined, RatingTitle="Other Plant").RatingScore,
 Machinery: LookUp(col_combined, RatingTitle="Machinery").RatingScore,
 'Power Tools': LookUp(col_combined, RatingTitle="Power Tools").RatingScore,
 'Hand Tools': LookUp(col_combined, RatingTitle="Hand Tools").RatingScore,
 'Tidiness - Construction Activities': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
 'Noise Levels': LookUp(col_combined, RatingTitle="Noise Levels").RatingScore,
 'Traffic Management': LookUp(col_combined, RatingTitle="Traffic Management").RatingScore,
 'Restricted Area': LookUp(col_combined, RatingTitle="Restricted Area").RatingScore
 }
 )
);

     

     

     

     

    EDIT 1:
    Now I'm just even more confused - I ran a quick check just to double check it was working. No issue:

    JeckGill_0-1695125068882.png

    Is there any reason it should be giving me a problem I'm not aware of?

     

    EDIT 2:
    Text(LookUp(col_combined, RatingTitle="Access / Egress").RatingScore) generates the exact same as the image in Edit 1 -  but makes no difference to the error this comment initially talks about 


    @VauBee Have you seen something similar before?

  • vaubeee Profile Picture
    vaubeee 533 on at

    @JeckGill 

    not 100% sure.. is "N/A" part of your Choice(s)-columns OptionSet-Values? Error says: Hey, I expect an OptionSetValue, but you're a giving me text... did you try to append .Value  or transform it to Value()?

     

    I'm still curious, if  

     

    ThisRecord.RatingTilte: ThisRecord.RatingScore,

     

    would work 😉

     

  • JeckGill Profile Picture
    JeckGill 242 on at

    absolutely positive that N/A is an option, however it's numerically assigned to 0

    JeckGill_5-1695195597881.png

     

    just to make sure I change the value selected and ran through it again on the check sheetunnamed.png

     

    wrapping it in Text() and Value () both get this

    JeckGill_3-1695195467565.png

     

    Appending .Text and .Value changes it to an error

    JeckGill_4-1695195533437.png

     

     

    I'm unsure how to use your 

    'Rating Score': ThisRecord.RatingScore, 

    lines would work - the collection that the ForAll is working from is different to the one where the ratings are stored so I don't think "ThisRecord" would work. The ForAll uses all in col_actionRequired; all these ratings are being taken specifically from col_combined. I have tried your "'Rating Score': col_combined[@RatingScore]" line but that didn't do much; which lead me down the LookUp path. I feel there is something obvious I'm missing but I've been staring at this problem for so long now I can't make heads or tails of it 😂

     

    I'll append code again at the end of this message- but here's the gist of what I am trying to do just incase it helps you understand my problem a bit more 😅

    col_actionRequired stores the name of a problem that received a rating of 1 or 2, as well as whatever the user has written in the app which would serve as a means to mitigate the issues. Each row will repost the same data except for the col_actionRequired parts; which means I have added a toggle just to tick off when the changes have been made.

    In the end, my PowerApps table will look (very very abstractly) like this:

    PrimaryKeyProblem titleProblem FixRatings 1-49
    key1PPEblah blah blahx x x x x x x
    key1Access/Egressblah blah blahx x x x x x x
    key2First Aidblah blah blahx x x x x x x
    key2Fire Precautionsblah blah blahx x x x x x x
    key2PPEblah blah blahx x x x x x x
    key3Tidinessblah blah blahx x x x x x x

     

    Here's the code again; if you have any more questions please do ask as I am at my wits end with this and I am so close to using my laptop as a sled to go down the stairs 😅

    ForAll(col_actionRequired,
 Patch(
 'Form - Site Inspection Reports',
 Defaults('Form - Site Inspection Reports'),
 {
 'Primary Key': _formName,
 Name: _uploaderName,
 'Project Number': _projectNumber,
 Signature: signatureOutput.Image,
 'Problem Area': problemArea,
 'Action Required': actionRequired,
 'Have the changes been made?': "No",

 'Rest Room / Canteen': LookUp(col_combined, RatingTitle="Rest Room / Canteen").RatingScore,
 'Changing Facilities': LookUp(col_combined, RatingTitle="Changing Facilities").RatingScore,
 'General Cleanliness': LookUp(col_combined, RatingTitle="General Cleanliness").RatingScore,
 'Site offices and welfare electrical cert in date': LookUp(col_combined, RatingTitle="Site offices & welfare electrical cert in date").RatingScore,
 'First aid facilities / first aider': LookUp(col_combined, RatingTitle="First Aid Facilities/ First Aider").RatingScore,
 Washing: LookUp(col_combined, RatingTitle="Washing").RatingScore,
 Sanitation: LookUp(col_combined, RatingTitle="Sanitation").RatingScore,
 PPE: LookUp(col_combined, RatingTitle="PPE").RatingScore,
 'Fire extinguisher checked & in date - welfare': LookUp(col_combined, RatingTitle="Fire extinguisher in date & checked").RatingScore,
 'Environmental Factors': LookUp(col_combined, RatingTitle="Environmental Factors").RatingScore,
 'Accident Records': LookUp(col_combined, RatingTitle="Accident Records").RatingScore,
 'Statutory forms / registers etc. ': LookUp(col_combined, RatingTitle="Statutory forms / Registers etc.").RatingScore,
 'Access / Egress': LookUp(col_combined, RatingTitle="Access / Egress").RatingScore.Value, //line with the current issue 
 'Signs & Notices': LookUp(col_combined, RatingTitle="Signs & Notices").RatingScore,
 'Tidiness - Storage Areas': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
 Flammables: LookUp(col_combined, RatingTitle="Flammables").RatingScore,
 Gases: LookUp(col_combined, RatingTitle="Gases").RatingScore,
 'Fuels & Lubricants': LookUp(col_combined, RatingTitle="Fuels / Lubricants").RatingScore,
 'Fire precautions - Storage Areas': LookUp(col_combined, RatingTitle="Fire Precautions").RatingScore,
 'Tools & Equipment': LookUp(col_combined, RatingTitle="Tools & Equipment").RatingScore,
 'Spillage kits': LookUp(col_combined, RatingTitle="Spillage Kits").RatingScore,
 'Access Equipment': LookUp(col_combined, RatingTitle="Access Equipment").RatingScore,
 'Dangerous Materials (COSHH)': LookUp(col_combined, RatingTitle="Dangerous Materials (COSHH)").RatingScore,
 'PAT Testing in date': LookUp(col_combined, RatingTitle="PAT Testing in date").RatingScore,
 'Quarantine Area': LookUp(col_combined, RatingTitle="Quarantine Area in place & used").RatingScore,
 'COSHH - SDS assessments': LookUp(col_combined, RatingTitle="COSHH - SDS Assessments in place").RatingScore,
 'LOLER in date': LookUp(col_combined, RatingTitle="LOLER in date").RatingScore,
 Scaffolding: LookUp(col_combined, RatingTitle="Scaffolding").RatingScore,
 'Ladders & Trestles': LookUp(col_combined, RatingTitle="Ladders / Trestles").RatingScore,
 'Working Platforms': LookUp(col_combined, RatingTitle="Working Platforms").RatingScore,
 Services: LookUp(col_combined, RatingTitle="Services").RatingScore,
 Security: LookUp(col_combined, RatingTitle="Security").RatingScore,
 'Extinguisher checked + in date - ConsAct': LookUp(col_combined, RatingTitle="Extinguisher in date").RatingScore,
 'Call points checked': LookUp(col_combined, RatingTitle="Call points checked").RatingScore,
 Electrical: LookUp(col_combined, RatingTitle="Electrical").RatingScore,
 Hoists: LookUp(col_combined, RatingTitle="Hoists").RatingScore,
 'Mobile Crane': LookUp(col_combined, RatingTitle="Mobile Crane").RatingScore,
 'Lifting Gear': LookUp(col_combined, RatingTitle="Lifting Gear").RatingScore,
 Excavations: LookUp(col_combined, RatingTitle="Excavations").RatingScore,
 Transport: LookUp(col_combined, RatingTitle="Transport").RatingScore,
 'Other Plant': LookUp(col_combined, RatingTitle="Other Plant").RatingScore,
 Machinery: LookUp(col_combined, RatingTitle="Machinery").RatingScore,
 'Power Tools': LookUp(col_combined, RatingTitle="Power Tools").RatingScore,
 'Hand Tools': LookUp(col_combined, RatingTitle="Hand Tools").RatingScore,
 'Tidiness - Construction Activities': LookUp(col_combined, RatingTitle="Tidiness").RatingScore,
 'Noise Levels': LookUp(col_combined, RatingTitle="Noise Levels").RatingScore,
 'Traffic Management': LookUp(col_combined, RatingTitle="Traffic Management").RatingScore,
 'Restricted Area': LookUp(col_combined, RatingTitle="Restricted Area").RatingScore
 }
 )
);

     

  • vaubeee Profile Picture
    vaubeee 533 on at

    @JeckGill 

    Change back to

     

    'Access / Egress': LookUp(col_combined, RatingTitle="Access / Egress").RatingScore,

     

    Is this the only column causing problems?

    Did you test the whole thing patching just one column to validate functionality?

     

    If it's only the 'Access ...'-column: is there any difference in this column compared to the other columns in your 'Form - Site Inspection Reports' table?

     

    Forget about ThisRecord...  didn't notice you're iterating over a different collection 👀

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans