Answered

Is it possible to change date in sharepoint list based on choice selected from dropdown?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am looking for ways, Is it possible to change date in sharepoint list based on choice selected from dropdown? leadtime added to today based on the selection of material.

Example, i have a list of material & their leadtime days needed by supplier to deliver to us

Today is 10.11.2020, when a material is choosen, example glass is choosen 10.11.2020 + 2 days = 12.11.2020

I have 3 columns in sharepoint list, Material, Leadtime & Date column.

Material Leadtime

glass +2 days

hardened glass +9 days

glass with film +4 days

painted glass +10 days

mirror +3 days

sandblasted mirror + 6 days

is it possible have such functions? please suggest me possibilities & formulas i can use either in sharepoint or in the powerapps customized form.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming you have a drop-down from a choices column for your materials, this should set the values you need

UpdateContext( { vLeadTime: Switch( YourMaterialDD.Selected.Value, "glass", 2, "hardened glass", 9, "glass with film" 4, "painted glass", 10, "mirror" 3, "sandblasted mirror" 6 ) } ); UpdateContext( { vLeadDate: DateAdd( Today(), vLeadTime, Days ) } ); Reset(YourLeadTimeControl); Reset(DateControl)

then the Default of Lead Time Control

If( vLeadTime>0, vLeadTime, Parent.Default )

the DefaultSelectedDate of Lead Date Control

If( vLeadDate=Blank(), Parent.Default, vLeadDate )

The at Screen OnVisible and/or at the end of your save code

UpdateContext( { vLeadDate:Blank(), vLeadTime:0 } )

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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,896 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No