Lookup an excel table

(0) Share

Report

Posted on by edymac2

Hi All,

I am having a little trouble trying to get results from an excel table stored on OneDrive,

I have a date picker to select the date (DataCardValue3) and a dropdown box t select the name (dd_DC), when these boxes have data entered I want PowerApps to lookup my excel table and return the corresponding result, I just cant get it to work.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Gochix 1,935 Moderator on at

Like (0)

Report

@edymac2 ,

The problem here is that the table header is a specific date.
If you wish the data to be displayed in the gallery then you can't tell the Filter function to -> get me the data where name is the one that is selected from dropdown menu and the DATE is the one that datepicker is set to. The column DATE is missing in your case and each column is a specific date.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
edymac2 70 on at

Like (0)

Report

Hi @Gochix,

I don't want it to be displayed in a gallery, I want a label to display the result,
do I need to set the table up differently ?

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (0)

Report

@edymac2 ,

Even then, ideally you want to have 3 columns. 1) Name 2) Date 3) Value. Then you can set the desired date and Name to pull the Value as a Result.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
Verified answer

edymac2 70 on at

Like (0)

Report

Hi @Gochix,

Unfortunately my table will have over 350 columns as its a yearly rota,
I have figured out away to do it but its a massive switch formula.

Switch(
DataCardValue3.SelectedDate,
DateValue("01/04/2024"),
LookUp(
SAndWRota,
Name = dd_DC.Selected.Value,
'01/04/2024'
),
DateValue("02/04/2024"),
LookUp(
SAndWRota,
Name = dd_DC.Selected.Value,
'02/04/2024'
),
DateValue("03/04/2024"),
LookUp(
SAndWRota,
Name = dd_DC.Selected.Value,
'03/04/2024'
)
) and so on.
This gives me the exact result I am looking for but is there an easier way to write this formula ?, could I put the date columns in a collection or maybe use a variable ?

Ed

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (1)

Report

@edymac2 ,

You can't use a variable here as the LookUp function will just display the variable instead of the actual data needed. At this point if you can't change the Table layout then I believe you will not going to be able to get the desired outcome. Unless, somebody else has a solution for you.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No