Problem using a DatePicker in PowerApps to update SharePoint via PowerAutomate

(0) Share

Report

Posted on by Bethany123

Hi,

I've been searching for ages on how to solve this, really appreciative any help.

I've been updating SharePoint via PowerApps and PowerAutomate, using Shane Youngs video as a guide, which was great. It all worked fine, the file was uploading and the fields were being updated until I tried to pass a date through with the datepicker. I just used the Dynamic Content "Ask in PowerApps" for all the file properties (which worked) except for the Date fields. The flow doesn't run at all now, not even a failed run, just nothing.

This is what I have in PowerApps:

Set(VarBase64Only,Mid(VarDemoAttachmentControl,Find(",",VarDemoAttachmentControl)+1,Len(VarDemoAttachmentControl)-Find(",",VarDemoAttachmentControl)-1) );
Set(varFileLink,'Copyof-EasyUpload'.Run(Last(AttachmentControl.Attachments).Name,VarBase64Only,SeniorManager.Selected.,FunctionDropdown.Selected.Value,DepartmentDropdown.Selected.Value,Approver.Selected.DisplayName, ,IssueInput.Text,Criticality.Selected.Value,ReviewPeriodInput.Text,DatePicker1.SelectedDate).sharepointfilelink);Reset(AttachmentControl)

The properties for DatePicker1 is set to Local, the SharePoint timezone is set to UTC,Edinburgh, Lisbon, London (i'm in the UK) and the Locale is set to "English".

I've tried using PowerAppsV2 but had another issues, so i'd like to stick with this version.

Really appreciate any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
Hi @Bethany123 ,

I obviously cannot see the "other end" of the Flow, but try sending this as the Date

Text(DatePicker1.SelectedDate, "yyyy-mm-dd")

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Bethany123 12 on at

Like (0)

Report

Hi @WarrenBelz ,

Do you know why I might be getting the error "unexpected characters. The formula contains 'Eof' where 'ParenClose' is expected.

This is now how it looks:
Set(VarDemoAttachmentControl,JSON(DoNotDelete.Image,JSONFormat.IncludeBinaryData));
Set(VarBase64Only,Mid(VarDemoAttachmentControl,Find(",",VarDemoAttachmentControl)+1,Len(VarDemoAttachmentControl)-Find(",",VarDemoAttachmentControl)-1) );
Set(varFileLink,'Copyof-EasyUpload'.Run(Last(AttachmentControl.Attachments).Name,VarBase64Only,SeniorManager.Selected.DisplayName,ExecManager.Selected.DisplayName,LineManager.Selected.DisplayName,TeamDropdown.Selected.Value,FunctionDropdown.Selected.Value,DepartmentDropdown.Selected.Value,Approver.Selected.DisplayName,AuthorDropDown.Selected.DisplayName,'Entity Level'.Selected.Value,IssueInput.Text,Criticality.Selected.Value,ReviewPeriodInput.Text,Text(DatePicker1.SelectedDate,"yyyy-mm-dd").sharepointfilelink);Reset(AttachmentControl)

Thanks,
Beth

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi @Bethany123 ,

If you parse it properly, you will see it

Set( varFileLink, 'Copyof-EasyUpload'.Run( Last( AttachmentControl.Attachments ).Name, VarBase64Only, SeniorManager.Selected.DisplayName, ExecManager.Selected.DisplayName, LineManager.Selected.DisplayName, TeamDropdown.Selected.Value, FunctionDropdown.Selected.Value, DepartmentDropdown.Selected.Value, Approver.Selected.DisplayName, AuthorDropDown.Selected.DisplayName, 'Entity Level'.Selected.Value, IssueInput.Text, Criticality.Selected.Value, ReviewPeriodInput.Text, Text(DatePicker1.SelectedDate,"yyyy-mm-dd") ).sharepointfilelink ); Reset(AttachmentControl)

extra bracket

Text(DatePicker1.SelectedDate,"yyyy-mm-dd"))

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Bethany123 12 on at

Like (0)

Report

@WarrenBelz Thankyou so much!! i can't tell you how many different posts i've created in different forums trying to get help with this. Its working, really grateful thank you.

Was this reply helpful? Yes No