Answered

Apps with multi excel board

(0) Share

Report

Posted on by bertrandedin

Hello,
I want to create an application to control and validate some data contained in Excel on my Onedrive.

I saw how to modify an Excel table, and it does not correspond to my wish.
because I don't like the 3 menus automatically offered by Power Apps (BrowseScreen, EditScreen and DetailScreen).
I would like a single SCREEN to read the data and check a box to validate line by line.

In my application, I would like to display 3 different Excel tables.
To begin, can you explain to me how to display 3 excel table in a blank application?


Thx

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

bertrandedin 49 on at

Like (0)

Report
Copy link

Link copied!

aiiie 😥,
no answer.

is my message not understandable?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @bertrandedin ,

I suggest you use three gallery controls or three data table controls to display the data of the excel table respectively.
If you want to choose a control to use, I suggest you use the gallery control, which is more stable.

I did a test for you.
1\ Add three tables .

2\ Add a gallery control and set Its Items property to:
Car

3\ Add a gallery control and set Its Items property to:
Van

4\ Add a gallery control and set Its Items property to:
Table1

5\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
bertrandedin 49 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft

I understood the operation thanks to you.

Just one more detail:
My Excel table contains 5 columns. How to change the value of the 5th by Ok or Nok ?

I inserted a textInput into the gallery with property Defaut = ThisItem.NameOfColone,
but my excel table does not change.

Was this reply helpful? Yes No