Announcements
See the screen shot below. I get the error: Variable 'DTCommunities' doesn't have a property '1'., but if I hardcode in 1 in place of the "DTRowFound" variable, it retrieves the row just fine. Anyone know what I'm missing here? Thanks!
I was able to solve this. I made a simply assumption that the "get subtext" action which stored the value in a variable was in number format but it was in text. I had to add a convert text to number since retrieving the row requires a number input and not text!
Use %DataTableMatches[0][0]% as input in a Convert text to number action, then use the output (%DTRowFound%) in your message box: %DTCommunities[DTRowFound]['EHR Community Name']%
Didn't see your reply, but yes that's exactly right. Very strange that the datatable values aren't numerical 🥴
The (very similar) Find and replace cells in Excel worksheet produces numerical values...
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 484
11manish 282
David_MA 280 Super User 2026 Season 1
