cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iwonder
Post Prodigy
Post Prodigy

Update a Yes No field in SharePoint List from Excel file

Thank you for taking the time to read my question.

 

I have a SharePoint list that I want to add some data to from an Excel file that has a data table. The list has 3 fields: Title, ProductName, IsActive.

 

In my flow I can add the Title values and the ProductName values but I can't seem to figure out how to add the IsActive value. I don't want it to be all Yes or all No, I need the value in the Excel file. I tried clicking on Enter custom value but don't understand what I need to do to get the IsActive value from Excel

 

iwonder_0-1618603238761.png

any help would be great.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
iwonder
Post Prodigy
Post Prodigy

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

View solution in original post

1 REPLY 1
iwonder
Post Prodigy
Post Prodigy

I created a variable and set the IsActive value to the variable vIsActive. Then I added the new variable to the Create Item.

 

iwonder_0-1618608296113.png

iwonder_1-1618608334026.png

 

That worked for me. Not sure if that's the right way but it's working

 

Thanks

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,178)