Here's my scenario: I have a table (Table1) with a list of Asset Classes and their Costs, and a second table (Table2) which has a list of assets, and their class. I'd like to be able to patch the cost of the asset class from table 1 to all the corresponding assets in table 2.
@RandyHayes thanks for the update, I still get the same error, re expecting text and getting a table.
@HenryARPhillips I did get your solution to work, however it didn't fill in all the lines. This may be a labelling issue on my end. I will try with a more concise number system for my Asset Class names instead of a text string and see if i can get them all to fill.
You all may have assumed this already but the scenario I presented was just a simplified version of the actual scenario. In reality its a 1000+ list of assets broken down into ~70 general categories.
Thanks for all your help folks, this place is a fantastic resource!
Should be working for you based on the original sample you provided.
If it is giving you an expected text and getting a table...where are you seeing that in the above formula?
Is Class_Cost as single text column? How about Asset_Class...single text?
_____________________________________________________________________________________ Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did. Check out my PowerApps Videos too!