web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Update a value

Power Apps

Answered

Update a value

(0) Share

Report

Report

Posted on by TiaanHarmse

18

Good day

Pleas assist me. I need to update a value in a gallery, below is what I need to do

1.Take above value Asset Tag

2. lookup the value in a collection under 'Type Name'

3. Take the Book Val

4.Update the value in the gallery

Please assist me in this regard.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

TiaanHarmse 18 on at

Like (0)

Report
Copy link

Link copied!

Good day
Please assist me, I need to update a value in a gallery based on a lookup in a collection. below is what I need to do.
1. Take the Value of asset tag
2.Lookup the value in a collection under 'Type Name'
3.Take the book value
4.and update the value in my gallery.
This needs to happen for all items in my gallery.
Thank you

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @TiaanHarmse

LookUp( CollectionName, 'Type name' = Value(AssetTagControlName.Text), 'Book value' )

Was this reply helpful? Yes No
TiaanHarmse 18 on at

Like (0)

Report
Copy link

Link copied!

Thank for the reply, see results below based on the function, am i doing something wrong?

Was this reply helpful? Yes No
Verified answer

Akser 1,546 Moderator on at

Like (0)

Report
Copy link

Link copied!
I just assumed that 'Type name' is a number (hence the Value() formula). Simply remove it:

LookUp( CollectionName, 'Type name' = AssetTagControlName.Text, 'Book value' )

Was this reply helpful? Yes No
TiaanHarmse 18 on at

Like (1)

Report
Copy link

Link copied!

That did the trick, Thank you very much

Was this reply helpful? Yes No

Join the conversation