cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dom_Mer
Regular Visitor

Media Image Reference - association with This-Item.'Name'

Dear Power-Apps Dream Team

I am asking for the help of an easy issue that I spotted during associations of two elements using the different Data Source.

Could You please sort a problem regarding associating the images (Stored in Power-App/Options-Collection) with the This-Item.-Asset-No selected in Browse-Gallery. (Please see the attached pictures).

Please see attached pictures of the Steps of the functions I put into App and the results :

1. Connection between two screens by selected Asset No. (Please see the attached picture)

2. To see Option-Collection:

I put a function :

App On-Start ( f x 😞
Clear-Collect(
Options-Collection,
{Asset-No:"1703", Image: '1703'},
{Asset-No:"1670", Image: '1703'},
{Asset-No:"692", Image: '1703'},
{Asset-No:"693", Image: '725 - Checkbox 07.20'}
)

(Please see the attached picture)

2. Proof that the Random Browse-Gallery with Options-Collection is working on random Screen
(Please see the attached picture)

My main problem is how to associate the Browse-Gallery-Main taking Data from SQL Server with unique picture (stored directly in Power-App ) for each item in Browse-Gallery-Main.

I am kindly asking for advice to avoid complications, I need to connect each item in Browse-Gallery with Unique picture.

Thank You in Advance for kind assistance in this matter.

Dominic

 
 

 

11 REPLIES 11

Dear Sir

You are My Hero and Legend, Sir. I knew it that is very simple but without Your, Sir help it would very hard to find a solution using formula containing (...) AssetNo = Trim (...). That is really amazing. I do not know how to Thank You, Sir! That is brilliant. Everything is working as it should.

 

Thank You in Your kind assistance in this matter.

 

Hope that one day I could help someone so I can compensate.

 

Best Regards

 

Dominic

@Dom_Mer 

I am glad it worked. 

Seeing the screen show of your data was the clue...you are using a nchar(10) on AssetNo.  That means that the field AssetNo will be padded with spaces for a length of 10. 

Comparing "123456" to "123456    " does not compare.

However "123456" does compare to Trim("123456    ")

So, that was what you needed.

 

Enjoy your PowerApp'ing.  You only need to repay by clicking on the Accept Solution button so that others will see that this is a solution and they can benefit from it as well.

 

_____________________________________________________________________________________
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!

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,783)