cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Update sharepoint list from excel data

Hi all,

 

I have the following flow that updates the data from an excel file to sharepoint list.

 

There is a column named 'Meldcode' which normally contains 4 numbers, i want to check if the 'Meldcode' contains 3 numbers i want to add a 0 at the beginning. For example if the output of 'Meldcode' = 465 than add a 0 at the beginning -->  0465 and than add it to the SharePoint list.

 

Anony_0-1618922513551.png

Anony_2-1618922614070.png

 

I also have a column in excel named 'Startdate', if I look at the output of Select array I see 5-7-2021(dd-mm-yyyy). If if want to update the data of sharepoint the column fills in with 7-5-2021(mm-dd-yyyy). How can i change this to dd-mm-yyyy and fill this in the sharepoint field?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Refer below example...

 

concat('0', variables('InputCode'))

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

3 REPLIES 3
PrasadAthalye
Super User
Super User

Please refer below... Check the length of Melcode and then use the Concat function to append 0.

 

PrasadAthalye_1-1618927130426.png

 

 

PrasadAthalye_0-1618927076393.png

 

For the date, use following function to convert the date from dd/mm to mm/dd and then save it to SharePoint date field. You can use compose for this.

 

formatDateTime('04/20/2021''MM/dd/yyyy')
 
Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Anonymous
Not applicable

Thanks for your reply!

 

What can i fill in the set variable field;

concat(..

Refer below example...

 

concat('0', variables('InputCode'))

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (27,252)