Hi folks. I am having problems after submitting sharepoint list item from power apps. The date and time which i have added is 26-01-2021 10:00AM BUT WHEN I SEE RESULT In sharepoint it shows as 10:00 PM. I tied tips from blogs and forums now all times like created , modified etc showing yesterday date and time even i create now. The date default value i set today so when i create new list item to check the default date shows as yesterday please help.
Facing the same issue. Not sure if this issue was resolved
Yah so as you said I changed Date time Zone in power apps to UTC and submitted form and I have modified Flow as when item is created -> convert time zone -> and then added that value to update item invite date and here is the result
After Approval and updated Time From convert time zone its 7:15 AM I don't understand anything at all why its happening.
In your flow you are converting from UTC so my last suggestion for you is on the powerapps you change the field to UTC and then you convert it the same way you currently do in powerautomate
The Value Is Local Only I have set.
I think the issue not on the Power Automate side ; the issue happening on the powerapp where you initially save the sharepoint list item , you need to save the correct in a correct way from the powerapps.
So in your powerapps on the datetime picker which value you are using in the below property
No After the approval I did not create item.
below I share steps please follow.
(When an form is submitted on power apps -> Create SharePoint List item)
then flow runs as below
when item is Created -> Send For Approval -> If Approve send email as approved if rejected send email as rejected. but in the form I have list column as Invite Date so its for visiting purpose if its approved then the meeting will be scheduled. so in flow I used converter to send proper time in Approval and Rejected Email. so only problem is in SharePoint list item date column.
Note :- even when in approval side before sending email I added update item action and added converted date but its giving entire some other time not related to anything.
Thanks
so after your approval you save the item in sharepoint ; is this correct ?
Please share the step where you save to the sharepoint list..
Yes I just created item directly from SharePoint list and its coming fine as I set. Date and Time.
Your setup looks good to me, if you create item directly in sharepoint, how does the date time look like.
So after i approved request with your name i added action that will updated list with id and i added date as converted expression but still its the same PM
you can see its approved and i have updated with new converted date but its still same