Hi everybody,
I am fairly new to PowerApps, and I would love to get some advice or suggestions on how to approach a project I am working on.
Project Details:
We are connected to a SQL Server where we are making a stored procedure request and receiving the data back in JSON format. I have been able to create a table using HtmlText and add the necessary additional data. In this particular case, we are displaying certain items from the database call, hence the procedural request.
We have successfully displayed the data using the HtmlText control, but I am facing an issue. When I create an HtmlText box and display the data, I am unable to retrieve the additional data from a dropdown menu for each row. While I can add the dropdown menu using HTML, I am not sure how to capture the selected values of these dropdown menus within an HtmlText.
Is there a way to get the values of the dropdown menus within an HtmlText in PowerApps? If not, what would be a better approach to achieve this functionality?
Thank you for your help!