How to Pass date to a Flow

(0) Share

Report

Posted on by AnuNampallu

I would like to update record in Dynamic 365.

Created a flow in PowerApps where i am passing, other parameters and they are getting updated On Save.

OnSelect of Save button:

UpdateRecord.Run(
Gallery1.Selected.activityid,
LookUp(data,_eis_area_label = DataCardValue26.Selected.Value,eis_area),
LookUp(data,_eis_district_label = DataCardValue27.Selected.Value,eis_district),
LookUp(data,_eis_region_label = DataCardValue24.Selected.Value,eis_region)
)

along with them i want to pass date and update it.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

There are two things you can try:
1) Simply passing the date as a date
2) Passing the date as text in format "yyyy-mm-dd", i.e. today would be "2018-03-19"

One of these or both should work.
AnuNampallu 16 on at

Like
a
(0)

Report
Copy link

Link copied!

On Save it should pick the date from screen.

But in PowerApps, card for Date is divided saperately for day,hour and minutes.
I belive i need to concatinate them and pass.

i tried this----

UpdateContext({Scheduledstart:Text(DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value),Value(MinuteValue1.Selected.Value),0))});
UpdateRecord.Run(
Gallery1.Selected.activityid,
Scheduledstart,
LookUp(data,_eis_area_label = DataCardValue26.Selected.Value,eis_area),
LookUp(data,_eis_district_label = DataCardValue27.Selected.Value,eis_district),
LookUp(data,_eis_region_label = DataCardValue24.Selected.Value,eis_region)
)

as of now i,m getting invalid number of arguments(which is true), as i didnt handle this extra parameter over there.

if this approach is fine, how should i handle it in flow.
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

You said 'date', what you mean is 'datetime', these are two different variable types.
However, your issue seems that you do not have the right number of parameters.
This is not set by PowerApps, but in Flow. Once the Flow is updated with the right number of parameters, you need to delete it and reconnect to it in PowerApps (I believe it is not possible to refresh as with other data sources).
Please let me know if this helps, and if not we can hop on a quick Skype call later today or tomorrow.
AnuNampallu 16 on at

Like
a
(0)

Report
Copy link

Link copied!

When i tried to update Flow, i'm not able to see Start Date automaticlly in Dynamic content.(Where i could see earlier columns like area,region and district).
Is there anything that i am missing?.

checked other card properties, for Update property they have -
DataSourceInfo(Meetings, DataSourceInfo.AllowedValues, "_eis_district_label")
but for Start Date -
DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)

By any chance, Is this is the reason behind not automatically getting Start Date in Dynamic Content.
Meneghino 6,949 on at

Like
a
(0)

Report
Copy link

Link copied!

In Flow you can normally use the 'ask in PowerApps' option to add a parameter to the flow.
AnuNampallu 16 on at

Like
a
(1)

Report
Copy link

Link copied!

I did tried with 'ask in PowerApps', where it was creating new column rather than showing all columns in datasource.

However, created another flow from scrach and while Update Record(action), i could able to see columns automatically when clicked on 'ask in PowerApps'.