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

Update sharepoint list by Excel and Secondary list using flow

Hi team,
Greetings..!!

I need to build a workflow on below criteria.
1. Excel file save in onedrive (contains Project manager Name with some other field).....file data change everyweek.
2. A sharepoint list which contains mrpject manager email.

3. team dont need to enter email address of Project manager manually everyweek so i use sharepoint secondary list to fetch the email address.
4. SO i create new Sharepoint list.
I create the two flows ,one is to get the items from excel and second is for fetch PM email address from sharepoint secondary list.

Please check the screenshot :- 

1. first Flow :-


Flow for excel.jpg

 

and my second flow is :- 

 

ExcelOnline10.png

ExcelOnline11.png

Now i need to merge both the flows in one flow.....


My email list and project list is :- 
Email list.pngProject list.png
 all the data in project list is coming from Excel file and email address of PM should pick from sharepoint email list,

i tried but need all these things in one Flow....kindly suggest the steps or screenshot for help.

Regards
Vikas Kaushik

9 REPLIES 9
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

If you want to merge both the flows in one flow,please take a try to add an "Get item" action under the "Create item" action in your first flow,and use the "Get item" action to replace the trigger “When an item is created” in the second flow.

 

Best regards,

Alice

Anonymous
Not applicable

Hi @v-yuazh-msft

 

Thanks for your reply.
I try with your solution....

but facing strange error....please check the below screenshot....everything is according to suggestion....

Error in flow merge.png

Please reply

Regards
Vikas Kaushik

Hi @Vikas,

 

Please add an "Get item" action not "Get items" action.

 

Please add the "Get item" action under the "Create item" action inside the Apply to each not outside the Apply to each.

 

 

Best regards,

Alice

Anonymous
Not applicable

Hi @v-yuazh-msft
Greetings..!!
Thanks for reply..!!
Please check the below steps,may be i am doing some mistake....

 

1. Flow :- first part is successfully running and fetching the data from excel file (in onedrive)

           but the second part is not working....
Merge1.pngmerge2.png

 

Formula for Initialize variable :-  first(split(triggerBody()?['Manager'],' '))

 

2. Email list :- 


Email List_1.png 

3. Project list :- 

 

 

project list_1.png

 

Please check and reply with some tips,frustated with this problem.

Regards
Vikas Kaushik

 

 

Hi @Anonymous,

 

The expression :

first(split(triggerBody()?['Manager'],' ')) 

is wrong.

 

Please replace the dynamic content to the "Get item", the value should get from the dynamic content of the "Get item" action instead of trigger.

 

Best regards,

Alice

Anonymous
Not applicable

Hi @v-yuazh-msft

The expression :

first(split(triggerBody()?['Manager'],' ')) 

is wrong. :- What will be the right expression (because manager is not one its more then 50 different people email list of manager)

 

Please replace the dynamic content to the "Get item", the value should get from the dynamic content of the "Get item" action instead of trigger. :- How to do this ? should i remove initialize varible option from the flow if yes please share the screen shot...
how to do this.....?

Regards
Vikas Kaushik

Hi @Anonymous:

 

Expression in the variable should be:

first(split(body('Get_item')?['ProjectManager'],''))

and

last(split(body('Get_item')?['ProjectManager'],''))

 

Best regards,

Alice

Anonymous
Not applicable

Hi @v-yuazh-msft

Thanks for supporting me....i am also trying with solution and some other ideas....but dont get success .

Apply to each.jpg

varibale.jpg 

 

Today i am trying all the things step by step as per your guidance but not able to solve the issue....i chnage the list column "Manager" into "ProjectManager".....cross check the first name and last name....
in the get item ProjectManager Name is successfully appearing after run the flow (in apply to each)....but after apply to each no success.....should i add initialize variable into the apply to each section ? i use as string and tried with as a integer or array also....
or i have to do something extra for this....please reply....

Regards
Vikas Kaushik

Anonymous
Not applicable

Hi @v-yuazh-msft

Did you check.....Please reply....

Regards
Vikas Kaushik

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,843)