Update the current date

(0) Share

Report

Posted on by CU08020114-0

Hello experts,

I am trying to do something smiliar to the excel sheet below in power apps.

to enter the quantity needed for each item on a spesfic date. the main problem, in the excel sheet. I use "Today ()" function then + 1 for the next cell.

I want the power apps, to show the today's date + 14 days automatacally without opening the excel sheet.

the excel sheet is located in sharepoint folder, and I have pro license.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

DavidZoon 738 Most Valuable Professional on at

Like (0)

Report

Hello,
Unfortunately you will not be able to represent your data in the same way because to be usable in Power apps a table must have fixed column names, but in your model you have dates in column names therefore dynamic values.

To be able to represent your tempo apps data you will need to have, for example, a table with an item column a date column and a quantity column.

If this answer has solved your problem, I invite you to mark it as solved. Also, do not hesitate to put a little like, it allows you to support the users who contribute to this forum.

Was this reply helpful? Yes No
Akshansh-Sharma 285 Moderator on at

Like (0)

Report

Hi,

As mentioned by David, it is a limitation of power apps tables as we don't have unlimited number of columns which we can use as and when we need but don't worry i understand your query and i think i can help you out but first i need additional input from your end i.e. can you please let me know till when you want to populate the columns with this logic (Today +14) if you can give me and end date i can suggest one solution for you.

--------------------------------------------------------------------------------------------------------------------

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up ‌‌

LinkedIn- https://www.linkedin.com/in/akshansharma/

Was this reply helpful? Yes No
CU08020114-0 4 on at

Like (0)

Report

Hello @Akshansh-Sharma, this is my point, I need at least 14 days from today, to be updated automatcally.

or I can create an excel sheet for around two years, but when importing to power apps, can it be limited to 14 days from today?

thanks in advance

Was this reply helpful? Yes No