Unanswered

Build a app from questions in excel rows

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a growing list of questions (for testing suites) that need to be addressed. I've been told I can use PowerApps for this. However, all my questions are different rows inside of one table. The table has columns:

ID	Nice_ID	Section	Test
1	1-logi	login screen	login screen has password widget
2	2-logi	login screen	login screen has user account widget
3	3-logi	login screen	login screen will show useful error when account credentials are wrong
4	4-logi	login screen	login screen will accept proper credentials

What I want is for n (where n=number of rows) text fields to pop up in power apps app, with the title text for each text field being a combination of the text in the columns. Example:

[1-logi] Login Screen has password widget - Login Screen

[2-logi] Login screen has user account widget - Login Screen

[3-logi] Login screen will show useful error when account credentials are wrong - Login Screen

[4-logi] Login screen will accept proper credentials - Login Screen

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

insert gallery
gallery.items = datasource

insert text label in gallery
label.text = Test
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is not an acceptable solution because my unique data is stored in the rows... not the column headers,
cds 1,001 on at

Like
a
(0)

Report
Copy link

Link copied!

table will populate in gallery.

since you are using excel, you may want to use a button to trigger a flow to get all rows present in table.

or just use a data table
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The table does populate in the gallery, but in a manner that is not useful based on my current data. The data that shows up in the textfield for each response is the column header. I don't want the column header. I need to create textfield objects, on a per ROW bases (not a per column basis) that will take the data from 3 cells in each row, combine those string values, and turn that in to the text for each textfield widget.

This will require some coding to complete. Any thoughts on how to do that?