cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerapps890
Post Prodigy
Post Prodigy

Display column value for each specific item

In my OnSuccess of a form I have Set(CurrentRec, formData.LastSubmit). Then in a gallery on the previous page I have a label with CurrentRec.Submit, the problem is all of the textboxes have the same value. How can I make it so the textbox is only showing the column value for each specific record. I tried to use ThisItem but no luck

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @powerapps890 ,

From your description, I know that:

1. Your Form and Gallery are connect to different DataSource. But they both have same column Title.

2. You want to show a label text from second DataSource inside the gallery when the records have same Title or ID.

 

Somethings like for example, I have two SP lists called "list9" and "list10". "list9" is the DataSource of my form, and "list10" is the DataSource of my gallery, I want to show list9.mode in my gallery when records have same Title:

v-albai-msft_0-1618989419912.png   

v-albai-msft_1-1618989429326.png

v-albai-msft_2-1618989585042.png

 

If my understanding is correct, I suggest you use Lookup to find the matched value. Set the Text property of your label inside Gallery to formula like this:

LookUp(DataSource2,Title=ThisItem.Title).Submit

Best regards,

Allen

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@powerapps890 

Your CurrentRec variable is going to be a single record.  Your Gallery represents a table of records.  

What is it that you are trying to accomplish?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Well each item in the form has an ID attached to it. The gallery and form datasources are different but they both have the same column title. So using the title or ID I was hoping to do some kind of match so the label would display the datacard value or column of the form. @RandyHayes 

v-albai-msft
Community Support
Community Support

Hi @powerapps890 ,

From your description, I know that:

1. Your Form and Gallery are connect to different DataSource. But they both have same column Title.

2. You want to show a label text from second DataSource inside the gallery when the records have same Title or ID.

 

Somethings like for example, I have two SP lists called "list9" and "list10". "list9" is the DataSource of my form, and "list10" is the DataSource of my gallery, I want to show list9.mode in my gallery when records have same Title:

v-albai-msft_0-1618989419912.png   

v-albai-msft_1-1618989429326.png

v-albai-msft_2-1618989585042.png

 

If my understanding is correct, I suggest you use Lookup to find the matched value. Set the Text property of your label inside Gallery to formula like this:

LookUp(DataSource2,Title=ThisItem.Title).Submit

Best regards,

Allen

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,816)