web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch Text column from...

Power Apps

Unanswered

Patch Text column from Collection into Choice Column in Table

(0) Share

Report

Report

Posted on by ashokpershad

321

I have a Dataverse Table with Lookup Column of Person Name form another Table.

I am using powerapps to create new data which I am storing in a collection with all fields matching Dataverse Table but this time everything in Text format. Now I want to Patch collection data into Dataverse table. What should be right patching format for Lookup Column and Date Columns.

Thanks in Advance

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Ram Prakash Duraisamy 5,699 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello @ashokpershad,

You Can easily path Lookup Column in DataVerse using below code

Patch(TABLENAME,Defaults(TABLENAME),{Name:"11",LOOKUPFIELDNAME:LookUp(DESINATIONLOOKUP,'DESTINATIONName'="COLLECTIONLOOKUPNAME") })

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
ashokpershad 321 on at

Like (0)

Report
Copy link

Link copied!
@rampprakash Thanks for your Answer but it is not working.
Let me try to explain in detail:
I have one Table in Dataverse (Manhours) with following columns:

Now I used one FORM for this table. When I press one submit button after filling details in this form I am creating one collection (displayed in Gallery5) too where I am storing all FORM submit entries. Please note this Submit button actually not for SUBMITFORM function.
Gallery5:
Now I want to Patch this Gallery back to my Dataverse Table using this ForAll and Patch functions.
I used Following Formula:

ForAll(Gallery5.AllItems, Patch(Manhours, Defaults(Manhours), {WOrder:glry5WO.Text, 'Lab Supervisor':LookUp(Manhours, 'Lab Supervisor'.Supervisor = glry5Sup.Text), 'Service Engineer': LookUp(Manhours, 'Service Engineer'.'Engineer Name' = glry5eng.Text), 'Date Started':glry5DS, 'Date Completed': glry5DE, 'Actual Work Hours': glry5AH.Text, Remarks: glry5Remarks.Text}))

But this formula is showing following error:

What formula shall I use?

I hope now its clear.

Was this reply helpful? Yes No

Join the conversation