automate a data change for 2023

(0) Share

Report

Posted on by TauGI

Hello,

I have an application that uses an Excel database.

I would like to automate the data change of my excel tables so that the data changes on January 1, 2023 without my intervention. Indeed, each year the data of my table changes.

I thought of creating a 2022 and a 2023 column and when I make a call, I put a condition:

 If(Text(Year(Now()))="2022"; LookUp(TabFamilles;Famillesachats=dcFamille.Selected.Famillesachats;'2022');
LookUp(TabFamilles;Famillesachats=dcFamille.Selected.Famillesachats;'2023'))

But it's not optimal, because it adds a lot of conditions in my code.

Thanks in advance to those who help.

Have a good day.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

TauGI 81 on at

Like
a
(0)

Report
Copy link

Link copied!
I also thought of changing the name of the column dynamically:

LookUp(TabFamilles;Famillesachats=dcFamille.Selected.Famillesachats;Text(Year(Now())))

But I feel like the column name can't be dynamic.
The values of my database will change every year, I have to find a solution to automate the change...

I'm also thinking about a power automaton flow that changes the values of the excel table in 2023...
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @TauGI ,

You cannot refer to columns dynamically in this structure, but you can do this

LookUp( TabFamilles; Famillesachats = dcFamille.Selected.Famillesachats; Switch( Year(Today())), 2022, '2022', 2023, '2023', 2024, '2024' ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps